DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_VENDORS

Line 1525: PO_VENDORS pv,

1521:
1522: CURSOR Cur_purchase_details IS
1523: SELECT UNIQUE pv.segment1
1524: FROM MTL_PARAMETERS mtl,
1525: PO_VENDORS pv,
1526: MTL_SYSTEM_ITEMS mitem,
1527: -- IC_ITEM_MST ic,
1528: PO_PO_SUPPLY_VIEW po
1529: WHERE po.item_id = mitem.inventory_item_id

Line 1548: PO_VENDORS pv,

1544:
1545: CURSOR Cur_receiving_details IS
1546: SELECT UNIQUE pv.segment1
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

Line 1571: PO_VENDORS pv,

1567: AND G_doc_type = 'PRCV'
1568: UNION ALL
1569: SELECT UNIQUE pv.segment1
1570: FROM MTL_PARAMETERS mtl,
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

Line 1594: PO_VENDORS pv,

1590: SELECT UNIQUE pv.segment1
1591: FROM MTL_PARAMETERS mtl,
1592: MTL_SYSTEM_ITEMS mitem,
1593: -- IC_ITEM_MST ic,
1594: PO_VENDORS pv,
1595: RCV_SHIPMENT_HEADERS rsh,
1596: PO_SHIP_SUPPLY_VIEW po
1597: WHERE po.item_id = mitem.inventory_item_id
1598: AND pv.vendor_id(+) = rsh.vendor_id