APPS.GMPMPACT dependencies on PO_REQ_SUPPLY_VIEW

Line 607: PO_REQ_SUPPLY_VIEW po

603: SELECT po.requisition_number
604: FROM MTL_PARAMETERS mtl,
605: MTL_SYSTEM_ITEMS mitem,
606: -- IC_ITEM_MST ic,
607: PO_REQ_SUPPLY_VIEW po
608: WHERE po.item_id = mitem.inventory_item_id
609: AND po.to_organization_id = mitem.organization_id
610: -- AND mitem.segment1 = ic.item_no
611: AND mtl.organization_id = po.to_organization_id

Line 958: ' po_req_supply_view po, mtl_system_items mitem '||

954: ' NULL )) trans_qty2, '||
955: ' po.req_line_id, mtl.organization_code '||
956: ' FROM MTL_PARAMETERS mtl, '||
957: ' hr_organization_units hou, '||
958: ' po_req_supply_view po, mtl_system_items mitem '||
959: ' WHERE po.item_id = TO_CHAR(:item_id) '||
960: ' AND po.item_id = mitem.inventory_item_id '||
961: ' AND po.to_organization_id = mitem.organization_id '||
962: ' AND mtl.organization_id = po.to_organization_id '||

Line 1618: PO_REQ_SUPPLY_VIEW po

1614: MTL_SYSTEM_ITEMS mitem,
1615: -- IC_ITEM_MST ic,
1616: -- IC_WHSE_MST iwm,
1617: PO_REQUISITION_LINES_ALL prl,
1618: PO_REQ_SUPPLY_VIEW po
1619: WHERE po.item_id = mitem.inventory_item_id
1620: AND po.req_line_id = prl.requisition_line_id
1621: AND po.to_organization_id = mitem.organization_id
1622: -- AND mitem.segment1 = ic.item_no