DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_VENDORS

Line 1533: PO_VENDORS pv,

1529: --Modified to vendor_name from segment1 as per bug # 11068148
1530: SELECT UNIQUE substr(pv.vendor_name,1,32)
1531: -- UNIQUE pv.segment1
1532: FROM MTL_PARAMETERS mtl,
1533: PO_VENDORS pv,
1534: MTL_SYSTEM_ITEMS mitem,
1535: -- IC_ITEM_MST ic,
1536: PO_PO_SUPPLY_VIEW po
1537: WHERE po.item_id = mitem.inventory_item_id

Line 1558: PO_VENDORS pv,

1554: --Modified to vendor_name from segment1 as per bug # 11068148
1555: SELECT UNIQUE substr(pv.vendor_name,1,32)
1556: -- UNIQUE pv.segment1
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

Line 1583: PO_VENDORS pv,

1579: --Modified to vendor_name from segment1 as per bug # 11068148
1580: SELECT UNIQUE substr(pv.vendor_name,1,32)
1581: -- UNIQUE pv.segment1
1582: FROM MTL_PARAMETERS mtl,
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

Line 1608: PO_VENDORS pv,

1604: -- UNIQUE pv.segment1
1605: FROM MTL_PARAMETERS mtl,
1606: MTL_SYSTEM_ITEMS mitem,
1607: -- IC_ITEM_MST ic,
1608: PO_VENDORS pv,
1609: RCV_SHIPMENT_HEADERS rsh,
1610: PO_SHIP_SUPPLY_VIEW po
1611: WHERE po.item_id = mitem.inventory_item_id
1612: AND pv.vendor_id(+) = rsh.vendor_id