Dear Friends Below is the query for Employees Position Hierarchy Query SELECT papf.person_number, hapft.name positionname FROM per_all_people_f papf, per_all_assignments_m paam, hr_all_positions_f hapf, hr_all_positions_f_tl hapft WHERE papf.person_id = paam.person_id AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date AND paam.primary_assignment_flag = 'Y' AND paam.assignment_type = 'E' AND paam.effective_latest_change = 'Y' AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date AND paam.position_id = hapf.position_id AND TRUNC(SYSDATE) BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND hapf.position_id = hapft.position_id AND hapft.language = 'US' AND TRUNC(SYSDATE) BETWE...
Posts
Dear Friends Below is the important queries for BI Report in Fusion on ON hand Quantities ------------------ON HAND QTY-------------- select ESI.ITEM_NUMBER , IODV.ORGANIZATION_NAME, ESI.DESCRIPTION , IOP.ORGANIZATION_CODE , SUM(IOQD.TRANSACTION_QUANTITY) TRX_QTY, UOMT.UNIT_OF_MEASURE , IOQD.SUBINVENTORY_CODE , IOQD.LOT_NUMBER, IIL.SEGMENT1, IIL.SEGMENT2, IIL.SEGMENT3, IIL.SEGMENT4 from INV_ONHAND_QUANTITIES_DETAIL IOQD , EGP_SYSTEM_ITEMS ESI , INV_ORG_PARAMETERS IOP , INV_ORGANIZATION_DEFINITIONS_V IODV, INV_UNITS_OF_MEASURE_TL UOMT , INV_UNITS_OF_MEASURE_B UOMB, INV_ITEM_LOCATIONS IIL where 1 = 1 and IODV.ORGANIZATION_ID =IOP.ORGANIZATION_ID and IOQD.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_ID and IOQD.ORGANIZATION_ID = ESI.ORGANIZATION_ID and ESI.ORGAN...
Dear Friends Here are a few important Fusion Quries for BI Reports in Fusion . The Below query will fetch the Purchase order Extracts with Business Units SELECT distinct haot.name "Business Unit" , pha.SEGMENT1 "Po Number" , PRHA.REQUISITION_NUMBER "Requisition Number" , '' "BPA Num" , pha.DOCUMENT_STATUS "Po HDR Status" , pla.LINE_STATUS "Po LN Status" , pda.DESTINATION_TYPE_CODE "PO Destination Type" , pha.TYPE_LOOKUP_CODE "Po Type" , pla.LINE_NUM "Line Number" , plla.Shipment_num "PO Schedule Num" , plla.INSPECTION_REQUIRED_FLAG , plla.SHIP_TO_ORGANIZATION_ID , pda.distribution_num "PO Distrubution Num" , MSIB.ITEM_NUMBER "Item" ,pla.ITEM_DESCRIPTION ,pla.QUANTITY "PO Quantity" ,rsl.QUANTITY_RECEIVED ,rs...
