35: SELECT
36: request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
37: ,order_source_id ,orig_sys_document_ref
38: ,NULL, NULL ,change_sequence
39: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
40: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
41: ,660 ,NULL ,NULL
42: ,NULL ,NULL ,NULL
43: ,'C' ,USERENV('LANG')
36: request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
37: ,order_source_id ,orig_sys_document_ref
38: ,NULL, NULL ,change_sequence
39: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
40: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
41: ,660 ,NULL ,NULL
42: ,NULL ,NULL ,NULL
43: ,'C' ,USERENV('LANG')
44: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
70: SELECT
71: request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
72: ,order_source_id ,orig_sys_document_ref
73: ,NULL, NULL ,change_sequence
74: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
75: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
76: ,660 ,NULL ,NULL
77: ,NULL ,NULL ,NULL
78: ,'C' ,USERENV('LANG')
71: request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
72: ,order_source_id ,orig_sys_document_ref
73: ,NULL, NULL ,change_sequence
74: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
75: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
76: ,660 ,NULL ,NULL
77: ,NULL ,NULL ,NULL
78: ,'C' ,USERENV('LANG')
79: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
110: SELECT
111: h.request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
112: ,order_source_id ,orig_sys_document_ref
113: ,NULL, NULL ,change_sequence
114: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
115: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
116: ,660 ,NULL ,NULL
117: ,NULL ,NULL ,NULL
118: ,'C' ,USERENV('LANG')
111: h.request_id ,'HEADER' ,NULL ,NULL ,NULL ,NULL
112: ,order_source_id ,orig_sys_document_ref
113: ,NULL, NULL ,change_sequence
114: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
115: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
116: ,660 ,NULL ,NULL
117: ,NULL ,NULL ,NULL
118: ,'C' ,USERENV('LANG')
119: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
152: SELECT
153: h.request_id ,'LINE' ,NULL ,NULL ,NULL ,NULL
154: ,l.order_source_id ,l.orig_sys_document_ref
155: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
156: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
157: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
158: ,660 ,NULL ,NULL
159: ,NULL ,NULL ,NULL
160: ,'C' ,USERENV('LANG')
153: h.request_id ,'LINE' ,NULL ,NULL ,NULL ,NULL
154: ,l.order_source_id ,l.orig_sys_document_ref
155: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
156: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
157: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
158: ,660 ,NULL ,NULL
159: ,NULL ,NULL ,NULL
160: ,'C' ,USERENV('LANG')
161: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
191: SELECT
192: h.request_id ,'LINE' ,NULL ,NULL ,NULL ,NULL
193: ,l.order_source_id ,l.orig_sys_document_ref
194: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
195: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
196: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
197: ,660 ,NULL ,NULL
198: ,NULL ,NULL ,NULL
199: ,'C' ,USERENV('LANG')
192: h.request_id ,'LINE' ,NULL ,NULL ,NULL ,NULL
193: ,l.order_source_id ,l.orig_sys_document_ref
194: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
195: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
196: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
197: ,660 ,NULL ,NULL
198: ,NULL ,NULL ,NULL
199: ,'C' ,USERENV('LANG')
200: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
235: h.request_id ,decode(l.orig_sys_line_ref||l.orig_sys_shipment_ref,NULL,'HEADER_ADJ','LINE_ADJ')
236: ,NULL ,NULL ,NULL ,NULL
237: ,l.order_source_id ,l.orig_sys_document_ref
238: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
239: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
240: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
241: ,660 ,NULL ,NULL
242: ,NULL ,NULL ,NULL
243: ,'C' ,USERENV('LANG')
236: ,NULL ,NULL ,NULL ,NULL
237: ,l.order_source_id ,l.orig_sys_document_ref
238: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, l.change_sequence
239: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
240: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
241: ,660 ,NULL ,NULL
242: ,NULL ,NULL ,NULL
243: ,'C' ,USERENV('LANG')
244: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
347: SELECT
348: request_id , 'HEADER',NULL,NULL,NULL,NULL
349: ,order_source_id ,orig_sys_document_ref ,NULL
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
348: request_id , 'HEADER',NULL,NULL,NULL,NULL
349: ,order_source_id ,orig_sys_document_ref ,NULL
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
382: SELECT
383: request_id ,'LINE',NULL,NULL,NULL,NULL
384: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
385: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
386: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
387: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
383: request_id ,'LINE',NULL,NULL,NULL,NULL
384: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
385: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
386: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
387: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
422: SELECT
423: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
424: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
423: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
424: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
458: SELECT
459: request_id , 'HEADER',NULL,NULL,NULL,NULL
460: ,order_source_id ,orig_sys_document_ref ,NULL
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
459: request_id , 'HEADER',NULL,NULL,NULL,NULL
460: ,order_source_id ,orig_sys_document_ref ,NULL
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
471: and FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
472: and FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
473: and FLV.LANGUAGE = userenv('LANG')
474: and FLV.VIEW_APPLICATION_ID = 3
475: and FLV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID)
476: AND FLV.LOOKUP_CODE = b.demand_class_code
477: AND FLV.LOOKUP_TYPE = 'DEMAND_CLASS'
478: AND FLT.APPLICATION_ID = 700
479: AND FLV.ENABLED_FLAG = 'Y'
513: SELECT
514: request_id ,'LINE',NULL,NULL,NULL,NULL
515: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
516: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
517: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
518: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
514: request_id ,'LINE',NULL,NULL,NULL,NULL
515: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
516: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
517: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
518: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
529: and FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
530: and FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
531: and FLV.LANGUAGE = userenv('LANG')
532: and FLV.VIEW_APPLICATION_ID = 3
533: and FLV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID)
534: AND FLV.LOOKUP_CODE = b.demand_class_code
535: AND FLV.LOOKUP_TYPE = 'DEMAND_CLASS'
536: AND FLT.APPLICATION_ID = 700
537: AND FLV.ENABLED_FLAG = 'Y'
574: SELECT
575: request_id , 'HEADER',NULL,NULL,NULL,NULL
576: ,order_source_id ,orig_sys_document_ref ,NULL
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
575: request_id , 'HEADER',NULL,NULL,NULL,NULL
576: ,order_source_id ,orig_sys_document_ref ,NULL
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
613: SELECT
614: request_id ,'LINE',NULL,NULL,NULL,NULL
615: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
616: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FOB_POINT_CODE'
617: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
618: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
614: request_id ,'LINE',NULL,NULL,NULL,NULL
615: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
616: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FOB_POINT_CODE'
617: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
618: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
656: SELECT
657: request_id , 'HEADER',NULL,NULL,NULL,NULL
658: ,order_source_id ,orig_sys_document_ref ,NULL
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
657: request_id , 'HEADER',NULL,NULL,NULL,NULL
658: ,order_source_id ,orig_sys_document_ref ,NULL
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
694: SELECT
695: request_id ,'LINE',NULL,NULL,NULL,NULL
696: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
697: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
698: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
699: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
695: request_id ,'LINE',NULL,NULL,NULL,NULL
696: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
697: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
698: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
699: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
736: SELECT
737: request_id , 'HEADER',NULL,NULL,NULL,NULL
738: ,order_source_id ,orig_sys_document_ref ,NULL
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
737: request_id , 'HEADER',NULL,NULL,NULL,NULL
738: ,order_source_id ,orig_sys_document_ref ,NULL
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
772: SELECT
773: request_id ,'LINE',NULL,NULL,NULL,NULL
774: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
775: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
776: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
777: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
773: request_id ,'LINE',NULL,NULL,NULL,NULL
774: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
775: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
776: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
777: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
813: SELECT
814: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
815: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
814: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
815: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
853: SELECT
854: request_id , 'HEADER',NULL,NULL,NULL,NULL
855: ,order_source_id ,orig_sys_document_ref ,NULL
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
854: request_id , 'HEADER',NULL,NULL,NULL,NULL
855: ,order_source_id ,orig_sys_document_ref ,NULL
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
889: SELECT
890: request_id ,'LINE',NULL,NULL,NULL,NULL
891: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
892: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
893: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
894: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
890: request_id ,'LINE',NULL,NULL,NULL,NULL
891: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
892: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
893: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
894: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
930: SELECT
931: request_id , 'HEADER',NULL,NULL,NULL,NULL
932: ,order_source_id ,orig_sys_document_ref ,NULL
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
931: request_id , 'HEADER',NULL,NULL,NULL,NULL
932: ,order_source_id ,orig_sys_document_ref ,NULL
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
966: SELECT
967: request_id ,'LINE',NULL,NULL,NULL,NULL
968: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
969: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
970: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
971: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
967: request_id ,'LINE',NULL,NULL,NULL,NULL
968: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
969: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
970: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
971: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1006: SELECT
1007: request_id , 'HEADER',NULL,NULL,NULL,NULL
1008: ,order_source_id ,orig_sys_document_ref ,NULL
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
1007: request_id , 'HEADER',NULL,NULL,NULL,NULL
1008: ,order_source_id ,orig_sys_document_ref ,NULL
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
1044: SELECT
1045: request_id ,'LINE',NULL,NULL,NULL,NULL
1046: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1047: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1048: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1049: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1045: request_id ,'LINE',NULL,NULL,NULL,NULL
1046: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1047: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1048: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1049: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1087: SELECT
1088: request_id , 'HEADER',NULL,NULL,NULL,NULL
1089: ,order_source_id ,orig_sys_document_ref ,NULL
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
1088: request_id , 'HEADER',NULL,NULL,NULL,NULL
1089: ,order_source_id ,orig_sys_document_ref ,NULL
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
1122: SELECT
1123: request_id ,'LINE',NULL,NULL,NULL,NULL
1124: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1125: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD_CODE'
1126: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1127: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1123: request_id ,'LINE',NULL,NULL,NULL,NULL
1124: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1125: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD_CODE'
1126: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1127: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1162: SELECT
1163: request_id , 'HEADER',NULL,NULL,NULL,NULL
1164: ,order_source_id ,orig_sys_document_ref ,NULL
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
1163: request_id , 'HEADER',NULL,NULL,NULL,NULL
1164: ,order_source_id ,orig_sys_document_ref ,NULL
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
1199: SELECT
1200: request_id ,'LINE',NULL,NULL,NULL,NULL
1201: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1202: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG_ID'
1203: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1204: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1200: request_id ,'LINE',NULL,NULL,NULL,NULL
1201: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1202: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG_ID'
1203: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1204: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1241: SELECT
1242: request_id , 'HEADER',NULL,NULL,NULL,NULL
1243: ,order_source_id ,orig_sys_document_ref ,NULL
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
1242: request_id , 'HEADER',NULL,NULL,NULL,NULL
1243: ,order_source_id ,orig_sys_document_ref ,NULL
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
1279: SELECT
1280: request_id ,'LINE',NULL,NULL,NULL,NULL
1281: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1282: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1283: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1284: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1280: request_id ,'LINE',NULL,NULL,NULL,NULL
1281: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1282: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1283: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1284: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1322: SELECT
1323: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1324: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1323: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1324: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1362: SELECT
1363: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1364: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1363: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1364: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1403: SELECT /* MOAC_SQL_CHANGE */
1404: request_id , 'HEADER',NULL,NULL,NULL,NULL
1405: ,order_source_id ,orig_sys_document_ref ,NULL
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
1404: request_id , 'HEADER',NULL,NULL,NULL,NULL
1405: ,order_source_id ,orig_sys_document_ref ,NULL
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
1452: SELECT /* MOAC_SQL_CHANGE */
1453: request_id ,'LINE',NULL,NULL,NULL,NULL
1454: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1455: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1456: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1457: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1453: request_id ,'LINE',NULL,NULL,NULL,NULL
1454: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1455: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1456: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1457: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1506: SELECT
1507: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1508: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1507: request_id , 'HEADER' ,NULL ,NULL ,NULL ,NULL
1508: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
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
1546: SELECT
1547: request_id ,'LINE',NULL,NULL,NULL,NULL
1548: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1549: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1550: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1551: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1547: request_id ,'LINE',NULL,NULL,NULL,NULL
1548: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1549: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1550: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1551: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1584: SELECT
1585: request_id ,'LINE',NULL,NULL,NULL,NULL
1586: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1587: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1588: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1589: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1585: request_id ,'LINE',NULL,NULL,NULL,NULL
1586: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1587: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1588: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1589: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1629: SELECT
1630: request_id ,'LINE',NULL,NULL,NULL,NULL
1631: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1632: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1633: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1634: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1630: request_id ,'LINE',NULL,NULL,NULL,NULL
1631: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1632: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1633: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1634: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1675: SELECT
1676: request_id ,'LINE',NULL,NULL,NULL,NULL
1677: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1678: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1679: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1680: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1676: request_id ,'LINE',NULL,NULL,NULL,NULL
1677: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1678: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1679: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1680: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1722: SELECT
1723: request_id ,'LINE',NULL,NULL,NULL,NULL
1724: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1725: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1726: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1727: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1723: request_id ,'LINE',NULL,NULL,NULL,NULL
1724: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1725: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1726: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1727: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1770: SELECT
1771: request_id ,'LINE',NULL,NULL,NULL,NULL
1772: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1773: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1774: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1775: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1771: request_id ,'LINE',NULL,NULL,NULL,NULL
1772: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1773: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1774: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1775: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1823: SELECT
1824: request_id ,'LINE',NULL,NULL,NULL,NULL
1825: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1826: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PREFERRED_GRADE'
1827: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1828: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1824: request_id ,'LINE',NULL,NULL,NULL,NULL
1825: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1826: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PREFERRED_GRADE'
1827: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1828: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
1876: SELECT
1877: request_id , 'HEADER',NULL,NULL,NULL,NULL
1878: ,order_source_id ,orig_sys_document_ref ,NULL
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
1877: request_id , 'HEADER',NULL,NULL,NULL,NULL
1878: ,order_source_id ,orig_sys_document_ref ,NULL
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
1911: SELECT
1912: request_id , 'HEADER',NULL,NULL,NULL,NULL
1913: ,order_source_id ,orig_sys_document_ref ,NULL
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
1912: request_id , 'HEADER',NULL,NULL,NULL,NULL
1913: ,order_source_id ,orig_sys_document_ref ,NULL
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
1961: SELECT
1962: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
1963: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
1962: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
1963: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
1997: SELECT
1998: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
1999: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
1998: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
1999: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2033: SELECT
2034: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2035: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2034: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2035: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2072: SELECT
2073: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2074: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2073: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2074: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2114: SELECT
2115: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2116: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2115: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2116: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2152: SELECT
2153: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2154: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2153: h.request_id,decode(orig_sys_line_ref,NULL,'HEADER_ADJ','LINE_ADJ'),NULL ,NULL ,NULL
2154: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
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
2193: SELECT
2194: request_id , 'HEADER',NULL,NULL,NULL,NULL
2195: ,order_source_id ,orig_sys_document_ref ,NULL
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
2194: request_id , 'HEADER',NULL,NULL,NULL,NULL
2195: ,order_source_id ,orig_sys_document_ref ,NULL
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
2230: SELECT
2231: request_id ,'LINE',NULL,NULL,NULL,NULL
2232: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
2233: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER_ID'
2234: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2235: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
2231: request_id ,'LINE',NULL,NULL,NULL,NULL
2232: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
2233: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER_ID'
2234: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2235: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
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
2316: SELECT
2317: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2318: ,l.order_source_id ,l.orig_sys_document_ref
2319: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2320: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2321: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2322: ,660 ,NULL ,NULL
2323: ,NULL ,NULL ,NULL
2324: ,'C' ,USERENV('LANG')
2317: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2318: ,l.order_source_id ,l.orig_sys_document_ref
2319: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2320: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2321: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2322: ,660 ,NULL ,NULL
2323: ,NULL ,NULL ,NULL
2324: ,'C' ,USERENV('LANG')
2325: ,l_msg_text || ' '|| l.ordered_item,
2359: SELECT
2360: OE_BULK_ORDER_PVT.G_REQUEST_ID ,'LINE' ,NULL,NULL ,NULL ,l.line_id
2361: ,l.order_source_id ,l.orig_sys_document_ref
2362: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2363: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2364: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2365: ,660 ,NULL ,NULL
2366: ,NULL ,NULL ,NULL
2367: ,'C' ,USERENV('LANG')
2360: OE_BULK_ORDER_PVT.G_REQUEST_ID ,'LINE' ,NULL,NULL ,NULL ,l.line_id
2361: ,l.order_source_id ,l.orig_sys_document_ref
2362: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2363: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2364: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2365: ,660 ,NULL ,NULL
2366: ,NULL ,NULL ,NULL
2367: ,'C' ,USERENV('LANG')
2368: ,l_msg_text ||' '||l.ordered_item || '( '||
2403: SELECT
2404: OE_BULK_ORDER_PVT.G_REQUEST_ID, 'LINE' ,NULL,NULL ,NULL ,l.line_id
2405: ,l.order_source_id ,l.orig_sys_document_ref
2406: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2407: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2408: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2409: ,660 ,NULL ,NULL
2410: ,NULL ,NULL ,NULL
2411: ,'C' ,USERENV('LANG')
2404: OE_BULK_ORDER_PVT.G_REQUEST_ID, 'LINE' ,NULL,NULL ,NULL ,l.line_id
2405: ,l.order_source_id ,l.orig_sys_document_ref
2406: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2407: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2408: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2409: ,660 ,NULL ,NULL
2410: ,NULL ,NULL ,NULL
2411: ,'C' ,USERENV('LANG')
2412: ,l_msg_text || ' '||l.ordered_item
2447: SELECT
2448: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2449: ,l.order_source_id ,l.orig_sys_document_ref
2450: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2451: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2452: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2453: ,660 ,NULL ,NULL
2454: ,NULL ,NULL ,NULL
2455: ,'C' ,USERENV('LANG')
2448: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2449: ,l.order_source_id ,l.orig_sys_document_ref
2450: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2451: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2452: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2453: ,660 ,NULL ,NULL
2454: ,NULL ,NULL ,NULL
2455: ,'C' ,USERENV('LANG')
2456: ,l_msg_text || ' '||l.ordered_item
2489: SELECT
2490: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2491: ,l.order_source_id ,l.orig_sys_document_ref
2492: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2493: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2494: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2495: ,660 ,NULL ,NULL
2496: ,NULL ,NULL ,NULL
2497: ,'C' ,USERENV('LANG')
2490: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2491: ,l.order_source_id ,l.orig_sys_document_ref
2492: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2493: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2494: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
2495: ,660 ,NULL ,NULL
2496: ,NULL ,NULL ,NULL
2497: ,'C' ,USERENV('LANG')
2498: ,l_msg_text || ' '||l.ordered_item