DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_RCV_SUPPLY_VIEW

Line 631: PO_RCV_SUPPLY_VIEW po

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

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

992: ' NULL)) trans_qty2, '||
993: ' po.po_line_id line_id, mtl.organization_code inv_org_code '||
994: ' FROM MTL_PARAMETERS mtl, '||
995: ' hr_organization_units hou, '||
996: ' po_rcv_supply_view po, mtl_system_items mitem '||
997: ' WHERE po.item_id = TO_CHAR(:item_id) '||
998: ' AND po.item_id = mitem.inventory_item_id '||
999: ' AND po.to_organization_id = mitem.organization_id '||
1000: ' AND mtl.organization_id = po.to_organization_id '||

Line 1561: PO_RCV_SUPPLY_VIEW po

1557: FROM MTL_PARAMETERS mtl,
1558: PO_VENDORS pv,
1559: MTL_SYSTEM_ITEMS mitem,
1560: -- IC_ITEM_MST ic,
1561: PO_RCV_SUPPLY_VIEW po
1562: WHERE po.item_id = mitem.inventory_item_id
1563: AND pv.vendor_id = po.vendor_id
1564: AND po.to_organization_id = mitem.organization_id
1565: -- AND mitem.segment1 = ic.item_no