DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_PO_SUPPLY_VIEW

Line 587: PO_PO_SUPPLY_VIEW po

583: SELECT po.po_number
584: FROM MTL_PARAMETERS mtl,
585: MTL_SYSTEM_ITEMS mitem,
586: -- IC_ITEM_MST ic,
587: PO_PO_SUPPLY_VIEW po
588: WHERE po.item_id = mitem.inventory_item_id
589: AND po.to_organization_id = mitem.organization_id
590: -- AND mitem.segment1 = ic.item_no
591: AND mtl.organization_id = po.to_organization_id

Line 932: ' po_po_supply_view po, mtl_system_items mitem '||

928: --' po.po_line_location_id line_id, mtl.organization_code inv_org_code '||
929: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
930: ' FROM MTL_PARAMETERS mtl, '||
931: ' hr_organization_units hou, '||
932: ' po_po_supply_view po, mtl_system_items mitem '||
933: ' WHERE po.item_id = TO_CHAR(:item_id) '||
934: ' AND po.item_id = mitem.inventory_item_id '||
935: ' AND po.to_organization_id = mitem.organization_id '||
936: ' AND mtl.organization_id = po.to_organization_id '||

Line 1536: PO_PO_SUPPLY_VIEW po

1532: FROM MTL_PARAMETERS mtl,
1533: PO_VENDORS pv,
1534: MTL_SYSTEM_ITEMS mitem,
1535: -- IC_ITEM_MST ic,
1536: PO_PO_SUPPLY_VIEW po
1537: WHERE po.item_id = mitem.inventory_item_id
1538: AND pv.vendor_id = po.vendor_id
1539: AND po.to_organization_id = mitem.organization_id
1540: -- AND mitem.segment1 = ic.item_no