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 OE_BLANKET_LINES_ALL

Line 893: FROM OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_ALL BL,

889: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
890: INTO x_blanket_number,
891: x_blanket_version_number,
892: x_blanket_line_number
893: FROM OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_ALL BL,
894: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
895: WHERE BH.HEADER_ID = BL.HEADER_ID
896: AND BL.CUST_PO_NUMBER = p_cust_po_number
897: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id

Line 1101: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_LINES_EXT BLE,

1097: BEGIN
1098:
1099: SELECT /* MOAC_SQL_CHANGE */ BH.VERSION_NUMBER
1100: INTO l_blanket_version_number
1101: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_LINES_EXT BLE,
1102: OE_BLANKET_HEADERS BH
1103: WHERE BLE.ORDER_NUMBER = p_x_line_rec.blanket_number
1104: AND BLE.LINE_NUMBER = p_x_line_rec.blanket_line_number
1105: AND BL.LINE_ID = BLE.LINE_ID