DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 710: FROM MTL_ONHAND_QUANTITIES onhand

706: ,onhand.inventory_item_id
707: ,SUM(onhand.transaction_quantity) primary_uom_qty
708: ,onhand.project_id
709: ,onhand.task_id
710: FROM MTL_ONHAND_QUANTITIES onhand
711: ,MTL_SYSTEM_ITEMS_B_KFV item_f -- the latest view for the item flexfield
712: WHERE onhand.organization_id = l_tp_inv_org_id
713: AND onhand.organization_id = item_f.organization_id
714: AND onhand.inventory_item_id = item_f.inventory_item_id