DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_RCV_SUPPLY_VIEW

Line 629: PO_RCV_SUPPLY_VIEW po

625: FROM MTL_PARAMETERS mtl,
626: MTL_SYSTEM_ITEMS mitem,
627: -- IC_ITEM_MST ic,
628: PO_HEADERS_ALL ph,
629: PO_RCV_SUPPLY_VIEW po
630: WHERE po.item_id = mitem.inventory_item_id
631: AND po.to_organization_id = mitem.organization_id
632: -- AND mitem.segment1 = ic.item_no
633: AND mtl.organization_id = po.to_organization_id

Line 990: ' po_rcv_supply_view po, mtl_system_items mitem '||

986: ' NULL)) trans_qty2, '||
987: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
988: ' FROM MTL_PARAMETERS mtl, '||
989: ' hr_organization_units hou, '||
990: ' po_rcv_supply_view po, mtl_system_items mitem '||
991: ' WHERE po.item_id = TO_CHAR(:item_id) '||
992: ' AND po.item_id = mitem.inventory_item_id '||
993: ' AND po.to_organization_id = mitem.organization_id '||
994: ' AND mtl.organization_id = po.to_organization_id '||

Line 1551: PO_RCV_SUPPLY_VIEW po

1547: FROM MTL_PARAMETERS mtl,
1548: PO_VENDORS pv,
1549: MTL_SYSTEM_ITEMS mitem,
1550: -- IC_ITEM_MST ic,
1551: PO_RCV_SUPPLY_VIEW po
1552: WHERE po.item_id = mitem.inventory_item_id
1553: AND pv.vendor_id = po.vendor_id
1554: AND po.to_organization_id = mitem.organization_id
1555: -- AND mitem.segment1 = ic.item_no