DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_SHIP_SUPPLY_VIEW

Line 671: PO_SHIP_SUPPLY_VIEW po

667: FROM MTL_PARAMETERS mtl,
668: MTL_SYSTEM_ITEMS mitem,
669: -- IC_ITEM_MST ic,
670: RCV_SHIPMENT_HEADERS rsh,
671: PO_SHIP_SUPPLY_VIEW po
672: WHERE po.item_id = mitem.inventory_item_id
673: AND po.shipment_header_id = rsh.shipment_header_id
674: AND po.to_organization_id = mitem.organization_id
675: -- AND mitem.segment1 = ic.item_no

Line 1050: ' po_ship_supply_view po, mtl_system_items mitem '||

1046: ' NULL)) trans_qty2, '||
1047: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1048: ' FROM MTL_PARAMETERS mtl, '||
1049: ' hr_organization_units hou, '||
1050: ' po_ship_supply_view po, mtl_system_items mitem '||
1051: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1052: ' AND po.item_id = mitem.inventory_item_id '||
1053: ' AND po.to_organization_id = mitem.organization_id '||
1054: ' AND mtl.organization_id = po.to_organization_id '||

Line 1596: PO_SHIP_SUPPLY_VIEW po

1592: MTL_SYSTEM_ITEMS mitem,
1593: -- IC_ITEM_MST ic,
1594: PO_VENDORS pv,
1595: RCV_SHIPMENT_HEADERS rsh,
1596: PO_SHIP_SUPPLY_VIEW po
1597: WHERE po.item_id = mitem.inventory_item_id
1598: AND pv.vendor_id(+) = rsh.vendor_id
1599: AND po.shipment_header_id = rsh.shipment_header_id
1600: AND po.to_organization_id = mitem.organization_id