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.INV_ATTRIBUTE_CONTROL_PVT dependencies on STANDARD

Line 287: and item_type_code in ('MODEL','STANDARD','OPTION')

283: from oe_order_lines_all
284: where source_type_code = 'EXTERNAL'
285: and open_flag = 'Y'
286: and nvl(shipped_quantity,0) = 0
287: and item_type_code in ('MODEL','STANDARD','OPTION')
288: and FLOW_STATUS_CODE = 'AWAITING_RECEIPT'
289: and inventory_item_id = p_item_id
290: and ship_from_org_id = p_org_id
291: and rownum = 1;

Line 386: and item_type_code in ('MODEL','STANDARD','OPTION')

382: from oe_order_lines_all
383: where source_type_code = 'EXTERNAL'
384: and open_flag = 'Y'
385: and nvl(shipped_quantity,0) = 0
386: and item_type_code in ('MODEL','STANDARD','OPTION')
387: and FLOW_STATUS_CODE = 'AWAITING_RECEIPT'
388: and inventory_item_id = p_item_id
389: -- bug 9558897, base bug 9327156, perf issue
390: and ship_from_org_id in (select organization_id