DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_REQ_SUPPLY_VIEW

Line 609: PO_REQ_SUPPLY_VIEW po

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

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

960: ' NULL )) trans_qty2, '||
961: ' po.req_line_id, mtl.organization_code '||
962: ' FROM MTL_PARAMETERS mtl, '||
963: ' hr_organization_units hou, '||
964: ' po_req_supply_view po, mtl_system_items mitem '||
965: ' WHERE po.item_id = TO_CHAR(:item_id) '||
966: ' AND po.item_id = mitem.inventory_item_id '||
967: ' AND po.to_organization_id = mitem.organization_id '||
968: ' AND mtl.organization_id = po.to_organization_id '||

Line 1632: PO_REQ_SUPPLY_VIEW po

1628: MTL_SYSTEM_ITEMS mitem,
1629: -- IC_ITEM_MST ic,
1630: -- IC_WHSE_MST iwm,
1631: PO_REQUISITION_LINES_ALL prl,
1632: PO_REQ_SUPPLY_VIEW po
1633: WHERE po.item_id = mitem.inventory_item_id
1634: AND po.req_line_id = prl.requisition_line_id
1635: AND po.to_organization_id = mitem.organization_id
1636: -- AND mitem.segment1 = ic.item_no