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) BETWEEN hapft.effective_start_date AND hapft.effective_end_date and    papf.person_number = nvl(:personnumber,papf.person_number) order by papf.person_number asc,

 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.ORGANIZATION_ID     = IOP.ORGANIZATION_ID and UOMT.UNIT_OF_MEASURE_ID = UOMB.UNIT_OF_MEASURE_ID and UOMB.UOM_CODE           = IOQD.TRANSACTION_UOM_CODE and IOQD.ORGANIZATION_ID   

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    ,rsl.QUANTITY_ACCEPTED    ,rsl.QUANTITY_DELIVERED    ,r