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_BULK_VALIDATE dependencies on OE_HEADERS_IFACE_ALL

Line 45: FROM OE_HEADERS_IFACE_ALL

41: ,660 ,NULL ,NULL
42: ,NULL ,NULL ,NULL
43: ,'C' ,USERENV('LANG')
44: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
45: FROM OE_HEADERS_IFACE_ALL
46: WHERE batch_id = p_batch_id
47: AND (order_source_id IS NULL OR orig_sys_document_ref IS NULL);
48:
49: IF g_error_count = 0 THEN

Line 80: FROM OE_HEADERS_IFACE_ALL h

76: ,660 ,NULL ,NULL
77: ,NULL ,NULL ,NULL
78: ,'C' ,USERENV('LANG')
79: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
80: FROM OE_HEADERS_IFACE_ALL h
81: WHERE batch_id = p_batch_id
82: AND EXISTS (SELECT 'Y'
83: FROM OE_ORDER_HEADERS oh
84: WHERE oh.order_source_id = h.order_source_id

Line 120: FROM OE_HEADERS_IFACE_ALL h

116: ,660 ,NULL ,NULL
117: ,NULL ,NULL ,NULL
118: ,'C' ,USERENV('LANG')
119: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
120: FROM OE_HEADERS_IFACE_ALL h
121: WHERE h.batch_id = p_batch_id
122: AND ( h.payment_type_code = 'CREDIT_CARD'
123: OR h.order_source_id = 10 -- 'Internal' Orders
124: OR h.customer_preference_set_code IS NOT NULL -- Value here requires lines to be in sets!

Line 162: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l

158: ,660 ,NULL ,NULL
159: ,NULL ,NULL ,NULL
160: ,'C' ,USERENV('LANG')
161: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
162: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
163: WHERE h.batch_id = p_batch_id
164: AND h.order_source_id = l.order_source_id
165: AND h.orig_sys_document_ref = l.orig_sys_document_ref
166: AND l.orig_sys_line_ref IS NULL

Line 201: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l

197: ,660 ,NULL ,NULL
198: ,NULL ,NULL ,NULL
199: ,'C' ,USERENV('LANG')
200: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
201: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
202: WHERE h.batch_id = p_batch_id
203: AND h.order_source_id = l.order_source_id
204: AND h.orig_sys_document_ref = l.orig_sys_document_ref
205: AND ( nvl(l.source_type_code,'INTERNAL') <> 'INTERNAL' -- Drop ships

Line 245: FROM OE_HEADERS_IFACE_ALL h, OE_PRICE_ADJS_INTERFACE l

241: ,660 ,NULL ,NULL
242: ,NULL ,NULL ,NULL
243: ,'C' ,USERENV('LANG')
244: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
245: FROM OE_HEADERS_IFACE_ALL h, OE_PRICE_ADJS_INTERFACE l
246: WHERE h.batch_id = p_batch_id
247: AND h.order_source_id = l.order_source_id
248: AND h.orig_sys_document_ref = l.orig_sys_document_ref
249: AND l.orig_sys_discount_ref IS NULL;

Line 354: FROM OE_HEADERS_IFACE_ALL b

350: ,NULL ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
351: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
352: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
353: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
354: FROM OE_HEADERS_IFACE_ALL b
355: WHERE batch_id = p_batch_id and
356: b.accounting_rule_id IS NOT NULL and
357: NOT EXISTS (SELECT RULE_ID
358: FROM OE_RA_RULES_V

Line 392: FROM OE_HEADERS_IFACE_ALL

388: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
389: FROM OE_LINES_IFACE_ALL b
390: WHERE (order_source_id, orig_sys_document_ref) IN
391: ( SELECT order_source_id, orig_sys_document_ref
392: FROM OE_HEADERS_IFACE_ALL
393: WHERE batch_id = p_batch_id)
394: AND b.accounting_rule_id IS NOT NULL and
395: NOT EXISTS (SELECT RULE_ID
396: FROM OE_RA_RULES_V

Line 429: FROM OE_HEADERS_IFACE_ALL b

425: ,change_sequence ,NULL ,NULL ,NULL ,'CONVERSION_TYPE'
426: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
427: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
428: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
429: FROM OE_HEADERS_IFACE_ALL b
430: WHERE batch_id = p_batch_id and
431: b.CONVERSION_TYPE_CODE IS NOT NULL and
432: NOT EXISTS (SELECT CONVERSION_TYPE
433: FROM OE_GL_DAILY_CONVERSION_TYPES_V a

Line 465: FROM OE_HEADERS_IFACE_ALL b

461: ,NULL ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
462: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
463: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
464: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
465: FROM OE_HEADERS_IFACE_ALL b
466: WHERE batch_id = p_batch_id and
467: b.demand_class_code IS NOT NULL and
468: NOT EXISTS (SELECT FLV.LOOKUP_CODE
469: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV

Line 523: FROM OE_HEADERS_IFACE_ALL

519: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
520: FROM OE_LINES_IFACE_ALL b
521: WHERE (order_source_id, orig_sys_document_ref) IN
522: ( SELECT order_source_id, orig_sys_document_ref
523: FROM OE_HEADERS_IFACE_ALL
524: WHERE batch_id = p_batch_id)
525: AND b.demand_class_code IS NOT NULL and
526: NOT EXISTS (SELECT FLV.LOOKUP_CODE
527: from FND_LOOKUP_TYPES FLT, FND_LOOKUP_VALUES FLV

Line 581: FROM OE_HEADERS_IFACE_ALL b

577: ,NULL ,change_sequence,NULL,NULL,NULL,'FOB_POINT'
578: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
579: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
580: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
581: FROM OE_HEADERS_IFACE_ALL b
582: WHERE batch_id = p_batch_id and
583: b.fob_point_code IS NOT NULL and
584: NOT EXISTS (SELECT LOOKUP_CODE
585: FROM OE_AR_LOOKUPS_V

Line 623: FROM OE_HEADERS_IFACE_ALL

619: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
620: FROM OE_LINES_IFACE_ALL b
621: WHERE (order_source_id, orig_sys_document_ref) IN
622: ( SELECT order_source_id, orig_sys_document_ref
623: FROM OE_HEADERS_IFACE_ALL
624: WHERE batch_id = p_batch_id)
625: AND b.fob_point_code IS NOT NULL and
626: NOT EXISTS (SELECT LOOKUP_CODE
627: FROM OE_AR_LOOKUPS_V

Line 663: FROM OE_HEADERS_IFACE_ALL b

659: ,NULL ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
660: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
661: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
662: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
663: FROM OE_HEADERS_IFACE_ALL b
664: WHERE batch_id = p_batch_id and
665: b.freight_terms_code IS NOT NULL and
666: NOT EXISTS (SELECT LOOKUP_CODE
667: FROM OE_LOOKUPS

Line 704: FROM OE_HEADERS_IFACE_ALL

700: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
701: FROM OE_LINES_IFACE_ALL b
702: WHERE (order_source_id, orig_sys_document_ref) IN
703: ( SELECT order_source_id, orig_sys_document_ref
704: FROM OE_HEADERS_IFACE_ALL
705: WHERE batch_id = p_batch_id)
706: AND b.freight_terms_code IS NOT NULL and
707: NOT EXISTS (SELECT LOOKUP_CODE
708: FROM OE_LOOKUPS

Line 743: FROM OE_HEADERS_IFACE_ALL b

739: ,NULL ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
740: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
741: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
742: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
743: FROM OE_HEADERS_IFACE_ALL b
744: WHERE batch_id = p_batch_id and
745: b.invoicing_rule_id IS NOT NULL and
746: NOT EXISTS (SELECT RULE_ID
747: FROM OE_RA_RULES_V

Line 782: FROM OE_HEADERS_IFACE_ALL

778: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
779: FROM OE_LINES_IFACE_ALL b
780: WHERE (order_source_id, orig_sys_document_ref) IN
781: ( SELECT order_source_id, orig_sys_document_ref
782: FROM OE_HEADERS_IFACE_ALL
783: WHERE batch_id = p_batch_id)
784: AND b.invoicing_rule_id IS NOT NULL and
785: NOT EXISTS (SELECT RULE_ID
786: FROM OE_RA_RULES_V

Line 820: FROM OE_HEADERS_IFACE_ALL b

816: ,change_sequence ,NULL ,NULL ,NULL ,'ORDER_DATE_TYPE_CODE'
817: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
818: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
819: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
820: FROM OE_HEADERS_IFACE_ALL b
821: WHERE batch_id = p_batch_id
822: AND b.order_date_type_code IS NOT NULL
823: AND NOT EXISTS (SELECT LOOKUP_CODE
824: FROM OE_LOOKUPS a

Line 860: FROM OE_HEADERS_IFACE_ALL b

856: ,NULL ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
857: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
858: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
859: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
860: FROM OE_HEADERS_IFACE_ALL b
861: WHERE batch_id = p_batch_id and
862: b.payment_term_id IS NOT NULL and
863: NOT EXISTS (select a.TERM_ID
864: FROM OE_RA_TERMS_V a

Line 899: FROM OE_HEADERS_IFACE_ALL

895: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
896: FROM OE_LINES_IFACE_ALL b
897: WHERE (order_source_id, orig_sys_document_ref) IN
898: ( SELECT order_source_id, orig_sys_document_ref
899: FROM OE_HEADERS_IFACE_ALL
900: WHERE batch_id = p_batch_id)
901: AND b.payment_term_id IS NOT NULL and
902: NOT EXISTS (select a.TERM_ID
903: FROM OE_RA_TERMS_V a

Line 937: FROM OE_HEADERS_IFACE_ALL b

933: ,NULL ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
934: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
935: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
936: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
937: FROM OE_HEADERS_IFACE_ALL b
938: WHERE batch_id = p_batch_id and
939: b.price_list_id IS NOT NULL and
940: NOT EXISTS (select list_header_id
941: FROM qp_list_headers_vl

Line 976: FROM OE_HEADERS_IFACE_ALL

972: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
973: FROM OE_LINES_IFACE_ALL b
974: WHERE (order_source_id, orig_sys_document_ref) IN
975: ( SELECT order_source_id, orig_sys_document_ref
976: FROM OE_HEADERS_IFACE_ALL
977: WHERE batch_id = p_batch_id)
978: AND b.price_list_id IS NOT NULL and
979: NOT EXISTS (select list_header_id
980: FROM qp_list_headers_vl

Line 1013: FROM OE_HEADERS_IFACE_ALL b

1009: ,NULL ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1010: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1011: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1012: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1013: FROM OE_HEADERS_IFACE_ALL b
1014: WHERE batch_id = p_batch_id and
1015: b.shipment_priority_code IS NOT NULL and
1016: NOT EXISTS (select LOOKUP_CODE
1017: FROM OE_LOOKUPS

Line 1054: FROM OE_HEADERS_IFACE_ALL

1050: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1051: FROM OE_LINES_IFACE_ALL b
1052: WHERE (order_source_id, orig_sys_document_ref) IN
1053: ( SELECT order_source_id, orig_sys_document_ref
1054: FROM OE_HEADERS_IFACE_ALL
1055: WHERE batch_id = p_batch_id)
1056: AND b.shipment_priority_code IS NOT NULL and
1057: NOT EXISTS (select LOOKUP_CODE
1058: FROM OE_LOOKUPS

Line 1094: FROM OE_HEADERS_IFACE_ALL b

1090: ,NULL ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD'
1091: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1092: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1093: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1094: FROM OE_HEADERS_IFACE_ALL b
1095: WHERE batch_id = p_batch_id and
1096: b.shipping_method_code IS NOT NULL and
1097: NOT EXISTS (select LOOKUP_CODE
1098: FROM OE_SHIP_METHODS_V

Line 1132: FROM OE_HEADERS_IFACE_ALL

1128: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1129: FROM OE_LINES_IFACE_ALL b
1130: WHERE (order_source_id, orig_sys_document_ref) IN
1131: ( SELECT order_source_id, orig_sys_document_ref
1132: FROM OE_HEADERS_IFACE_ALL
1133: WHERE batch_id = p_batch_id)
1134: AND b.shipping_method_code IS NOT NULL and
1135: NOT EXISTS (select LOOKUP_CODE
1136: FROM OE_SHIP_METHODS_V

Line 1169: FROM OE_HEADERS_IFACE_ALL b

1165: ,NULL ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG'
1166: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1167: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1168: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1169: FROM OE_HEADERS_IFACE_ALL b
1170: WHERE batch_id = p_batch_id and
1171: b.sold_to_org_id IS NOT NULL and
1172: NOT EXISTS (select ORGANIZATION_ID
1173: FROM OE_SOLD_TO_ORGS_V

Line 1209: FROM OE_HEADERS_IFACE_ALL

1205: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1206: FROM OE_LINES_IFACE_ALL b
1207: WHERE (order_source_id, orig_sys_document_ref) IN
1208: ( SELECT order_source_id, orig_sys_document_ref
1209: FROM OE_HEADERS_IFACE_ALL
1210: WHERE batch_id = p_batch_id)
1211: AND b.sold_to_org_id IS NOT NULL and
1212: NOT EXISTS (select ORGANIZATION_ID
1213: FROM OE_SOLD_TO_ORGS_V

Line 1248: FROM OE_HEADERS_IFACE_ALL b

1244: ,NULL ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1245: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1246: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1247: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1248: FROM OE_HEADERS_IFACE_ALL b
1249: WHERE batch_id = p_batch_id and
1250: b.tax_exempt_flag IS NOT NULL and
1251: NOT EXISTS (SELECT LOOKUP_CODE
1252: FROM OE_AR_LOOKUPS_V

Line 1289: FROM OE_HEADERS_IFACE_ALL

1285: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1286: FROM OE_LINES_IFACE_ALL b
1287: WHERE (order_source_id, orig_sys_document_ref) IN
1288: ( SELECT order_source_id, orig_sys_document_ref
1289: FROM OE_HEADERS_IFACE_ALL
1290: WHERE batch_id = p_batch_id)
1291: AND b.tax_exempt_flag IS NOT NULL and
1292: NOT EXISTS (SELECT LOOKUP_CODE
1293: FROM OE_AR_LOOKUPS_V

Line 1329: FROM OE_HEADERS_IFACE_ALL b

1325: ,change_sequence ,NULL ,NULL ,NULL ,'TRANSACTIONAL_CURR_CODE'
1326: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1327: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1328: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1329: FROM OE_HEADERS_IFACE_ALL b
1330: WHERE batch_id = p_batch_id and
1331: b.transactional_curr_code IS NOT NULL and
1332: NOT EXISTS (SELECT CURRENCY_CODE
1333: FROM OE_FND_CURRENCIES_V

Line 1369: FROM OE_HEADERS_IFACE_ALL b

1365: ,change_sequence ,NULL ,NULL ,NULL ,'PAYMENT_TYPE_CODE'
1366: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1367: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1368: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1369: FROM OE_HEADERS_IFACE_ALL b
1370: WHERE batch_id = p_batch_id and
1371: b.payment_type_code IS NOT NULL and
1372: NOT EXISTS (SELECT LOOKUP_CODE
1373: FROM OE_LOOKUPS

Line 1410: FROM OE_HEADERS_IFACE_ALL b

1406: ,NULL ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1407: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1408: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1409: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1410: FROM OE_HEADERS_IFACE_ALL b
1411: WHERE batch_id = p_batch_id
1412: AND b.salesrep_id IS NOT NULL
1413: AND NOT EXISTS (SELECT a.salesrep_id
1414: from ra_salesreps_all a

Line 1462: FROM OE_HEADERS_IFACE_ALL

1458: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1459: FROM OE_LINES_IFACE_ALL b
1460: WHERE (order_source_id, orig_sys_document_ref) IN
1461: ( SELECT order_source_id, orig_sys_document_ref
1462: FROM OE_HEADERS_IFACE_ALL
1463: WHERE batch_id = p_batch_id)
1464: AND b.salesrep_id IS NOT NULL
1465: AND NOT EXISTS (SELECT a.salesrep_id
1466: from ra_salesreps_all a

Line 1513: FROM OE_HEADERS_IFACE_ALL b

1509: ,change_sequence ,NULL ,NULL ,NULL ,'SALES_CHANNEL_CODE'
1510: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1511: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1512: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1513: FROM OE_HEADERS_IFACE_ALL b
1514: WHERE batch_id = p_batch_id and
1515: b.sales_channel_code IS NOT NULL and
1516: NOT EXISTS (SELECT LOOKUP_CODE
1517: FROM OE_LOOKUPS

Line 1556: FROM OE_HEADERS_IFACE_ALL

1552: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1553: FROM OE_LINES_IFACE_ALL b
1554: WHERE (order_source_id, orig_sys_document_ref) IN
1555: ( SELECT order_source_id, orig_sys_document_ref
1556: FROM OE_HEADERS_IFACE_ALL
1557: WHERE batch_id = p_batch_id)
1558: AND b.end_item_unit_number IS NOT NULL and
1559: NOT EXISTS (SELECT unit_number
1560: FROM pjm_unit_numbers_lov_v

Line 1594: FROM OE_HEADERS_IFACE_ALL

1590: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1591: FROM OE_LINES_IFACE_ALL b
1592: WHERE (order_source_id, orig_sys_document_ref) IN
1593: ( SELECT order_source_id, orig_sys_document_ref
1594: FROM OE_HEADERS_IFACE_ALL
1595: WHERE batch_id = p_batch_id)
1596: AND NVL(b.calculate_price_flag,'Y') NOT IN ('Y','P','N');
1597:
1598: IF g_error_count = 0 THEN

Line 1639: FROM OE_HEADERS_IFACE_ALL

1635: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1636: FROM OE_LINES_IFACE_ALL b
1637: WHERE (order_source_id, orig_sys_document_ref) IN
1638: ( SELECT order_source_id, orig_sys_document_ref
1639: FROM OE_HEADERS_IFACE_ALL
1640: WHERE batch_id = p_batch_id)
1641: -- Added to fix bug 5394064. Validate this ID only if populated
1642: AND b.inventory_item_id IS NOT NULL -- added to fix bug 5394064
1643: AND NOT EXISTS (

Line 1685: FROM OE_HEADERS_IFACE_ALL

1681: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1682: FROM OE_LINES_IFACE_ALL b
1683: WHERE (order_source_id, orig_sys_document_ref) IN
1684: ( SELECT order_source_id, orig_sys_document_ref
1685: FROM OE_HEADERS_IFACE_ALL
1686: WHERE batch_id = p_batch_id)
1687: AND ( b.ordered_quantity_uom2 IS NOT NULL
1688: OR b.ordered_quantity2 IS NOT NULL )
1689:

Line 1732: FROM OE_HEADERS_IFACE_ALL

1728: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1729: FROM OE_LINES_IFACE_ALL b
1730: WHERE (order_source_id, orig_sys_document_ref) IN
1731: ( SELECT order_source_id, orig_sys_document_ref
1732: FROM OE_HEADERS_IFACE_ALL
1733: WHERE batch_id = p_batch_id)
1734: AND ( b.ordered_quantity_uom2 IS NOT NULL )
1735: AND NOT EXISTS (
1736: SELECT tracking_quantity_ind

Line 1780: FROM OE_HEADERS_IFACE_ALL

1776: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1777: FROM OE_LINES_IFACE_ALL b
1778: WHERE (order_source_id, orig_sys_document_ref) IN
1779: ( SELECT order_source_id, orig_sys_document_ref
1780: FROM OE_HEADERS_IFACE_ALL
1781: WHERE batch_id = p_batch_id)
1782: AND ( b.ordered_quantity_uom2 IS NULL)
1783:
1784: AND EXISTS (

Line 1833: FROM OE_HEADERS_IFACE_ALL

1829: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1830: FROM OE_LINES_IFACE_ALL b
1831: WHERE (order_source_id, orig_sys_document_ref) IN
1832: ( SELECT order_source_id, orig_sys_document_ref
1833: FROM OE_HEADERS_IFACE_ALL
1834: WHERE batch_id = p_batch_id)
1835: AND b.preferred_grade IS NOT NULL
1836: AND b.ship_from_org_id IS NOT NULL
1837: AND b.inventory_item_id IS NOT NULL

Line 1883: FROM OE_HEADERS_IFACE_ALL b

1879: ,NULL ,change_sequence,NULL,NULL,NULL,'TRANSACTION_PHASE_CODE'
1880: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1881: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1882: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1883: FROM OE_HEADERS_IFACE_ALL b
1884: WHERE batch_id = p_batch_id and
1885: b.transaction_phase_code IS NOT NULL
1886: -- Only fulfillment orders are supported for HVOP
1887: AND nvl(b.transaction_phase_code,'F') <> 'F'

Line 1918: FROM OE_HEADERS_IFACE_ALL b

1914: ,NULL ,change_sequence,NULL,NULL,NULL,'VERSION_NUMBER'
1915: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1916: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1917: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1918: FROM OE_HEADERS_IFACE_ALL b
1919: WHERE batch_id = p_batch_id and
1920: b.version_number IS NOT NULL
1921: -- Version number cannot be negative or in decimals
1922: AND (b.version_number < 0

Line 1968: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

1964: ,a.change_sequence ,NULL ,NULL ,NULL ,'APPLIED_FLAG'
1965: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1966: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1967: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1968: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
1969: WHERE h.batch_id = p_batch_id
1970: AND a.order_source_id = h.order_source_id
1971: AND a.orig_sys_document_ref = h.orig_sys_document_ref
1972: AND a.APPLIED_FLAG IS NOT NULL

Line 2004: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2000: ,a.change_sequence ,NULL ,NULL ,NULL ,'INCLUDE_ON_RETURNS_FLAG'
2001: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2002: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2003: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2004: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2005: WHERE h.batch_id = p_batch_id
2006: AND a.order_source_id = h.order_source_id
2007: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2008: AND a.INCLUDE_ON_RETURNS_FLAG IS NOT NULL

Line 2040: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2036: ,a.change_sequence ,NULL ,NULL ,NULL ,'CREDIT_OR_CHARGE_FLAG'
2037: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2039: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2040: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2041: WHERE h.batch_id = p_batch_id
2042: AND a.order_source_id = h.order_source_id
2043: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2044: AND a.CREDIT_OR_CHARGE_FLAG IS NOT NULL

Line 2079: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2075: ,a.change_sequence ,NULL ,NULL ,NULL ,'CHARGE_TYPE_CODE'
2076: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2077: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2078: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2079: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2080: WHERE h.batch_id = p_batch_id
2081: AND a.order_source_id = h.order_source_id
2082: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2083: AND a.CHARGE_TYPE_CODE IS NOT NULL

Line 2121: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2117: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_HEADER_ID'
2118: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2119: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2120: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2121: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2122: WHERE h.batch_id = p_batch_id
2123: AND a.order_source_id = h.order_source_id
2124: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2125: AND a.list_header_id IS NOT NULL

Line 2159: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2155: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_LINE_ID'
2156: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2157: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2158: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2159: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2160: WHERE h.batch_id = p_batch_id
2161: AND a.order_source_id = h.order_source_id
2162: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2163: AND a.list_line_id IS NOT NULL

Line 2200: FROM OE_HEADERS_IFACE_ALL b

2196: ,NULL ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER'
2197: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2198: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
2199: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2200: FROM OE_HEADERS_IFACE_ALL b
2201: WHERE batch_id = p_batch_id and
2202: b.sold_to_org_id IS NOT NULL and
2203: NOT EXISTS (select ORGANIZATION_ID
2204: FROM OE_SOLD_TO_ORGS_V

Line 2240: FROM OE_HEADERS_IFACE_ALL

2236: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2237: FROM OE_LINES_IFACE_ALL b
2238: WHERE (order_source_id, orig_sys_document_ref) IN
2239: ( SELECT order_source_id, orig_sys_document_ref
2240: FROM OE_HEADERS_IFACE_ALL
2241: WHERE batch_id = p_batch_id)
2242: AND b.sold_to_org_id IS NOT NULL and
2243: NOT EXISTS (select ORGANIZATION_ID
2244: FROM OE_SOLD_TO_ORGS_V

Line 2573: FROM OE_HEADERS_IFACE_ALL a,OE_CONFIG_DETAILS_TMP t

2569: SET ERROR_FLAG = 'Y'
2570: ,ATTRIBUTE_STATUS = NULL
2571: WHERE (order_source_id, orig_sys_document_ref,orig_sys_line_ref) in
2572: (SELECT a.order_source_id, a.orig_sys_document_ref,t.orig_sys_line_ref
2573: FROM OE_HEADERS_IFACE_ALL a,OE_CONFIG_DETAILS_TMP t
2574: where a.batch_id=p_batch_id
2575: AND a.orig_sys_document_ref=t.orig_sys_document_ref
2576: AND a.order_source_id=t.order_source_id
2577: AND t.orig_sys_line_ref is not NULL

Line 2587: UPDATE OE_HEADERS_IFACE_ALL h

2583: END;
2584:
2585: ELSE
2586: BEGIN
2587: UPDATE OE_HEADERS_IFACE_ALL h
2588: SET ERROR_FLAG = 'Y'
2589: ,ATTRIBUTE_STATUS = NULL
2590: WHERE batch_id = p_batch_id
2591: AND nvl(ERROR_FLAG, 'N') = 'N'

Line 2642: UPDATE oe_headers_iface_all a

2638: when others then
2639: NULL;
2640: END;
2641:
2642: UPDATE oe_headers_iface_all a
2643: SET error_flag = 'Y'
2644: ,attribute_status = NULL
2645: WHERE batch_id = p_batch_id
2646: AND nvl(error_flag,'N') = 'N'

Line 2658: UPDATE oe_headers_iface_all a

2654:
2655: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2656: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2657:
2658: UPDATE oe_headers_iface_all a
2659: SET error_flag = 'Y'
2660: ,attribute_status = NULL
2661: WHERE batch_id = p_batch_id
2662: AND nvl(error_flag,'N') = 'N'

Line 2678: UPDATE OE_HEADERS_IFACE_ALL a

2674:
2675:
2676: ELSE
2677:
2678: UPDATE OE_HEADERS_IFACE_ALL a
2679: SET ERROR_FLAG = 'Y'
2680: ,ATTRIBUTE_STATUS = NULL
2681: WHERE batch_id = p_batch_id
2682: AND nvl(ERROR_FLAG, 'N') = 'N'

Line 2701: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b

2697: UPDATE OE_LINES_IFACE_ALL c
2698: SET ATTRIBUTE_STATUS = NULL
2699: WHERE (order_source_id, orig_sys_document_ref) IN
2700: (SELECT a.order_source_id, a.orig_sys_document_ref
2701: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b
2702: WHERE a.batch_id = p_batch_id
2703: AND b.original_sys_document_ref = a.ORIG_SYS_DOCUMENT_REF
2704: AND b.order_source_id = a.order_source_id
2705: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID);--Added for bug 6830039