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 687: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

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

Line 714: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

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

Line 762: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

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

Line 783: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

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

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

Line 911: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,

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

Line 1183: OE_BLANKET_HEADERS_ALL BH,

1179: x_blanket_line_number,
1180: x_blanket_version_number
1181:
1182: FROM OE_BLANKET_LINES BL,
1183: OE_BLANKET_HEADERS_ALL BH,
1184: OE_BLANKET_HEADERS_EXT BHE,
1185: OE_BLANKET_LINES_EXT BLE
1186: WHERE BH.ORDER_NUMBER = p_blanket_number
1187: AND BL.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID

Line 1209: OE_BLANKET_HEADERS_ALL BH,

1205: x_blanket_line_number,
1206: x_blanket_version_number
1207:
1208: FROM OE_BLANKET_LINES BL,
1209: OE_BLANKET_HEADERS_ALL BH,
1210: OE_BLANKET_HEADERS_EXT BHE,
1211: OE_BLANKET_LINES_EXT BLE
1212: WHERE BH.ORDER_NUMBER = p_blanket_number
1213: AND BH.HEADER_ID = BL.HEADER_ID