DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_SHIP_RCV_SUPPLY_VIEW

Line 654: PO_SHIP_RCV_SUPPLY_VIEW po

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
658: -- AND mitem.segment1 = ic.item_no

Line 1028: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||

1024: ' NULL)) trans_qty2, '||
1025: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1026: ' FROM MTL_PARAMETERS mtl, '||
1027: ' hr_organization_units hou, '||
1028: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||
1029: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1030: ' AND po.item_id = mitem.inventory_item_id '||
1031: ' AND po.to_organization_id = mitem.organization_id '||
1032: ' AND mtl.organization_id = po.to_organization_id '||

Line 1587: PO_SHIP_RCV_SUPPLY_VIEW po

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
1591: AND po.to_organization_id = mitem.organization_id