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 2341: FROM oe_order_lines_all

2337: ordered_item_id,
2338: org_id,
2339: inventory_item_id,
2340: sold_to_org_id
2341: FROM oe_order_lines_all
2342: WHERE header_id = p_doc_id
2343: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2344: AND item_identifier_type <> 'CAT'
2345: ORDER BY ordered_item;

Line 2364: FROM oe_order_lines_all

2360:
2361: --cursor to retrieve the item categories (CATs) in the Sales Order
2362: --returns non-translatable code eg. 208.05
2363: SELECT ordered_item
2364: FROM oe_order_lines_all
2365: WHERE header_id = p_doc_id
2366: AND p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE
2367: AND item_identifier_type = 'CAT'
2368: ORDER BY ordered_item;

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

2370:
2371:
2372:
2373: -- cursor to retrieve categories to which the INT (internal) and non-INT items in the BSA or Sales Order belong
2374: /** Note: the inventory_item_id stored in OE_BLANKET_LINES_ALL OE_ORDER_LINES_ALL against the non-INT item is
2375: that of the mapped INT item so we can use it directly to get the item category **/
2376: -- returns non-translatable code eg. HOSPITAL.MISC
2377: CURSOR c_get_derived_item_category (cp_org_id NUMBER,
2378: cp_inventory_item_id NUMBER) IS