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 101: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

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

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

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

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

269: AND ( NVL(pll.closed_code, 'OPEN') NOT IN
270: ( 'FINALLY CLOSED', 'CLOSED',
271: 'CLOSED FOR RECEIVING')))
272: )
273: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
274: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
275: AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id)
276: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
277:

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

336: AND ( NVL(pll.closed_code, 'OPEN') NOT IN
337: ( 'FINALLY CLOSED', 'CLOSED',
338: 'CLOSED FOR RECEIVING')))
339: )
340: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
341: AND pll.ship_to_organization_id =NVL(rsl.to_organization_id, pll.ship_to_organization_id)
342: AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id)
343: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
344: