DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_SHIP_SUPPLY_VIEW

Line 673: PO_SHIP_SUPPLY_VIEW po

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

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

1052: ' NULL)) trans_qty2, '||
1053: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1054: ' FROM MTL_PARAMETERS mtl, '||
1055: ' hr_organization_units hou, '||
1056: ' po_ship_supply_view po, mtl_system_items mitem '||
1057: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1058: ' AND po.item_id = mitem.inventory_item_id '||
1059: ' AND po.to_organization_id = mitem.organization_id '||
1060: ' AND mtl.organization_id = po.to_organization_id '||

Line 1610: PO_SHIP_SUPPLY_VIEW po

1606: MTL_SYSTEM_ITEMS mitem,
1607: -- IC_ITEM_MST ic,
1608: PO_VENDORS pv,
1609: RCV_SHIPMENT_HEADERS rsh,
1610: PO_SHIP_SUPPLY_VIEW po
1611: WHERE po.item_id = mitem.inventory_item_id
1612: AND pv.vendor_id(+) = rsh.vendor_id
1613: AND po.shipment_header_id = rsh.shipment_header_id
1614: AND po.to_organization_id = mitem.organization_id