DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on RCV_SHIPMENT_HEADERS

Line 653: RCV_SHIPMENT_HEADERS rsh,

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

Line 672: RCV_SHIPMENT_HEADERS rsh,

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

Line 1586: RCV_SHIPMENT_HEADERS rsh,

1582: FROM MTL_PARAMETERS mtl,
1583: PO_VENDORS pv,
1584: MTL_SYSTEM_ITEMS mitem,
1585: -- IC_ITEM_MST ic,
1586: RCV_SHIPMENT_HEADERS rsh,
1587: PO_SHIP_RCV_SUPPLY_VIEW po
1588: WHERE po.item_id = mitem.inventory_item_id
1589: AND pv.vendor_id = rsh.vendor_id
1590: AND po.shipment_header_id = rsh.shipment_header_id

Line 1609: RCV_SHIPMENT_HEADERS rsh,

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