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_HEADERS_ALL

Line 689: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

685: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
686: INTO x_blanket_number,
687: x_blanket_version_number,
688: x_blanket_line_number
689: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
690: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
691: WHERE BH.HEADER_ID = BL.HEADER_ID
692: AND BL.CUST_PO_NUMBER = p_cust_po_number
693: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id

Line 716: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

712: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
713: INTO x_blanket_number,
714: x_blanket_version_number,
715: x_blanket_line_number
716: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
717: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
718: WHERE BH.HEADER_ID = BL.HEADER_ID
719: AND BH.ORDER_NUMBER = l_blanket_number
720: -- Do not match customer if blanket number is supplied

Line 764: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

760: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
761: INTO x_blanket_number,
762: x_blanket_version_number,
763: x_blanket_line_number
764: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
765: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
766: WHERE BH.HEADER_ID = BL.HEADER_ID
767: AND BL.CUST_PO_NUMBER = p_cust_po_number
768: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id

Line 785: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

781: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
782: INTO x_blanket_number,
783: x_blanket_version_number,
784: x_blanket_line_number
785: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
786: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
787: WHERE BH.HEADER_ID = BL.HEADER_ID
788: AND BH.ORDER_NUMBER = l_blanket_number
789: -- Do not match customer if blanket number is supplied

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

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

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

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

Line 913: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

909: SELECT /* MOAC_SQL_CHANGE */ BH.ORDER_NUMBER, BH.VERSION_NUMBER, BL.LINE_NUMBER
910: INTO x_blanket_number,
911: x_blanket_version_number,
912: x_blanket_line_number
913: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
914: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
915: WHERE BH.HEADER_ID = BL.HEADER_ID
916: AND BH.ORDER_NUMBER = l_blanket_number
917: -- Do not match customer if blanket number is supplied

Line 1245: OE_BLANKET_HEADERS_ALL BH,

1241: x_blanket_line_number,
1242: x_blanket_version_number
1243:
1244: FROM OE_BLANKET_LINES BL,
1245: OE_BLANKET_HEADERS_ALL BH,
1246: OE_BLANKET_HEADERS_EXT BHE,
1247: OE_BLANKET_LINES_EXT BLE
1248: WHERE BH.ORDER_NUMBER = p_blanket_number
1249: AND BL.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID

Line 1271: OE_BLANKET_HEADERS_ALL BH,

1267: x_blanket_line_number,
1268: x_blanket_version_number
1269:
1270: FROM OE_BLANKET_LINES BL,
1271: OE_BLANKET_HEADERS_ALL BH,
1272: OE_BLANKET_HEADERS_EXT BHE,
1273: OE_BLANKET_LINES_EXT BLE
1274: WHERE BH.ORDER_NUMBER = p_blanket_number
1275: AND BH.HEADER_ID = BL.HEADER_ID