DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_SHIP_RCV_SUPPLY_VIEW

Line 652: PO_SHIP_RCV_SUPPLY_VIEW po

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

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

1018: ' NULL)) trans_qty2, '||
1019: ' po.shipment_line_id line_id, mtl.organization_code inv_org_code '||
1020: ' FROM MTL_PARAMETERS mtl, '||
1021: ' hr_organization_units hou, '||
1022: ' po_ship_rcv_supply_view po, mtl_system_items mitem '||
1023: ' WHERE po.item_id = TO_CHAR(:item_id) '||
1024: ' AND po.item_id = mitem.inventory_item_id '||
1025: ' AND po.to_organization_id = mitem.organization_id '||
1026: ' AND mtl.organization_id = po.to_organization_id '||

Line 1575: PO_SHIP_RCV_SUPPLY_VIEW po

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