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_DEFAULT_LINE dependencies on MTL_ITEM_CATEGORIES

Line 825: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC,

821: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
822: INTO x_blanket_number,
823: x_blanket_version_number,
824: x_blanket_line_number
825: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC,
826: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
827: WHERE BH.HEADER_ID = BL.HEADER_ID
828: AND BL.CUST_PO_NUMBER = p_cust_po_number
829: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id

Line 848: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC

844: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
845: INTO x_blanket_number,
846: x_blanket_version_number,
847: x_blanket_line_number
848: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC
849: ,OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
850: WHERE BH.HEADER_ID = BL.HEADER_ID
851: AND BH.ORDER_NUMBER = l_blanket_number
852: -- Do not match customer if blanket number is supplied