DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on RCV_SHIPMENT_HEADERS

Line 651: RCV_SHIPMENT_HEADERS rsh,

647: SELECT rsh.receipt_num
648: FROM MTL_PARAMETERS mtl,
649: MTL_SYSTEM_ITEMS mitem,
650: -- IC_ITEM_MST ic,
651: RCV_SHIPMENT_HEADERS rsh,
652: PO_SHIP_RCV_SUPPLY_VIEW po
653: WHERE po.item_id = mitem.inventory_item_id
654: AND po.shipment_header_id = rsh.shipment_header_id
655: AND po.to_organization_id = mitem.organization_id

Line 670: RCV_SHIPMENT_HEADERS rsh,

666: SELECT rsh.receipt_num
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

Line 1574: RCV_SHIPMENT_HEADERS rsh,

1570: FROM MTL_PARAMETERS mtl,
1571: PO_VENDORS pv,
1572: MTL_SYSTEM_ITEMS mitem,
1573: -- IC_ITEM_MST ic,
1574: RCV_SHIPMENT_HEADERS rsh,
1575: PO_SHIP_RCV_SUPPLY_VIEW po
1576: WHERE po.item_id = mitem.inventory_item_id
1577: AND pv.vendor_id = rsh.vendor_id
1578: AND po.shipment_header_id = rsh.shipment_header_id

Line 1595: RCV_SHIPMENT_HEADERS rsh,

1591: FROM MTL_PARAMETERS mtl,
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