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_EXT

Line 688: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
692: AND BHE.ON_HOLD_FLAG = 'N'

Line 715: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
719: -- With 11.5.10, customer on blanket could be

Line 763: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
767: AND BHE.ON_HOLD_FLAG = 'N'

Line 784: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
788: -- With 11.5.10, customer on blanket could be

Line 826: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
830: AND BHE.ON_HOLD_FLAG = 'N'

Line 849: ,OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
853: -- With 11.5.10, customer on blanket could be

Line 892: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

888: INTO x_blanket_number,
889: x_blanket_version_number,
890: x_blanket_line_number
891: FROM OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_ALL BL,
892: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
893: WHERE BH.HEADER_ID = BL.HEADER_ID
894: AND BL.CUST_PO_NUMBER = p_cust_po_number
895: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
896: AND BHE.ON_HOLD_FLAG = 'N'

Line 912: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE

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
916: -- With 11.5.10, customer on blanket could be

Line 1040: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_LINES_EXT BLE,

1036: BEGIN
1037:
1038: SELECT /* MOAC_SQL_CHANGE */ BH.VERSION_NUMBER
1039: INTO l_blanket_version_number
1040: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_LINES_EXT BLE,
1041: OE_BLANKET_HEADERS BH
1042: WHERE BLE.ORDER_NUMBER = p_x_line_rec.blanket_number
1043: AND BLE.LINE_NUMBER = p_x_line_rec.blanket_line_number
1044: AND BL.LINE_ID = BLE.LINE_ID

Line 1185: OE_BLANKET_LINES_EXT BLE

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
1188: AND BH.HEADER_ID = BL.HEADER_ID
1189: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER

Line 1211: OE_BLANKET_LINES_EXT BLE

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
1214: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
1215: AND BL.LINE_ID = BLE.LINE_ID