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.OE_CONTRACTS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2332: FROM oe_order_lines_all

2328: ordered_item_id,
2329: org_id,
2330: inventory_item_id,
2331: sold_to_org_id
2332: FROM oe_order_lines_all
2333: WHERE header_id = p_doc_id
2334: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2335: AND item_identifier_type <> 'CAT'
2336: ORDER BY ordered_item;

Line 2355: FROM oe_order_lines_all

2351:
2352: --cursor to retrieve the item categories (CATs) in the Sales Order
2353: --returns non-translatable code eg. 208.05
2354: SELECT ordered_item
2355: FROM oe_order_lines_all
2356: WHERE header_id = p_doc_id
2357: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2358: AND item_identifier_type = 'CAT'
2359: ORDER BY ordered_item;

Line 2365: /** Note: the inventory_item_id stored in OE_BLANKET_LINES_ALL OE_ORDER_LINES_ALL against the non-INT item is

2361:
2362:
2363:
2364: -- cursor to retrieve categories to which the INT (internal) and non-INT items in the BSA or Sales Order belong
2365: /** Note: the inventory_item_id stored in OE_BLANKET_LINES_ALL OE_ORDER_LINES_ALL against the non-INT item is
2366: that of the mapped INT item so we can use it directly to get the item category **/
2367: -- returns non-translatable code eg. HOSPITAL.MISC
2368: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2369: cp_inventory_item_id NUMBER) IS