eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on STANDARD

Line 103: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

99: ( NVL(pll.closed_code, 'OPEN') NOT IN
100: ( 'FINALLY CLOSED', 'CLOSED',
101: 'CLOSED FOR RECEIVING')))
102: )
103: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
104: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
105: --AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id) - Bug 7677745
106: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'))
107: ORDER BY NVL(pll.promised_date, pll.need_by_date);

Line 164: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

160: AND ( NVL(pll.closed_code, 'OPEN') NOT IN
161: ( 'FINALLY CLOSED', 'CLOSED',
162: 'CLOSED FOR RECEIVING')))
163: )
164: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
165: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
166: --AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id) -Bug 7677745
167: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
168:

Line 277: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

273: AND ( NVL(pll.closed_code, 'OPEN') NOT IN
274: ( 'FINALLY CLOSED', 'CLOSED',
275: 'CLOSED FOR RECEIVING')))
276: )
277: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
278: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
279: --AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id) - Bug 7677745
280: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
281:

Line 344: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

340: AND ( NVL(pll.closed_code, 'OPEN') NOT IN
341: ( 'FINALLY CLOSED', 'CLOSED',
342: 'CLOSED FOR RECEIVING')))
343: )
344: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
345: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
346: --AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id) -Bug 7677745
347: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
348: