APPS.OE_BULK_VALIDATE dependencies on FND_GLOBAL

Line 39: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 40: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 74: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 75: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 114: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 115: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 156: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 157: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 195: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 196: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 239: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 240: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 351: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 352: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 386: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 387: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 426: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 427: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 462: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 463: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 475: and FLV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID)

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'

Line 517: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 518: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 533: and FLV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID)

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'

Line 578: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 579: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 617: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 618: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 660: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 661: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 698: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 699: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 740: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 741: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 776: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 777: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 817: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 818: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 857: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 858: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 893: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 894: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 934: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 935: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 970: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 971: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1010: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1011: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1048: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1049: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1091: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1092: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1126: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1127: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1166: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1167: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1203: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1204: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1245: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1246: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1283: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1284: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1326: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1327: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 1366: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1367: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 1407: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1408: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1456: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1457: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1510: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1511: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 1550: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1551: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1588: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1589: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1633: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1634: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1679: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1680: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1726: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1727: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1774: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1775: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1827: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1828: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1880: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1881: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1915: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1916: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 1965: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 1966: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2001: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2002: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2037: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2038: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2076: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2077: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2118: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2119: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2156: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2157: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL

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

Line 2197: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_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

Line 2198: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 2234: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID

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

Line 2235: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL

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

Line 2320: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 2321: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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,

Line 2363: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 2364: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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 || '( '||

Line 2407: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate

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')

Line 2408: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 2451: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate

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')

Line 2452: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 2493: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate

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')

Line 2494: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

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