APPS.OKS_IMPORT_INSERT dependencies on FND_GLOBAL

Line 26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;

22: --========================================================================
23: -- PRIVATE CONSTANTS AND VARIABLES
24: --========================================================================
25: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

Line 137: ,FND_GLOBAL.USER_ID CREATED_BY

133: ,'N' DELETED_YN
134: ,'N' TEMPLATE_YN
135: ,'CYA' CHR_TYPE
136: ,1 OBJECT_VERSION_NUMBER
137: ,FND_GLOBAL.USER_ID CREATED_BY
138: ,SYSDATE CREATION_DATE
139: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
140: ,NVL(HDRSTG.PO_REQUIRED,'N') PO_REQUIRED
141: ,HDRSTG.SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ

Line 139: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

135: ,'CYA' CHR_TYPE
136: ,1 OBJECT_VERSION_NUMBER
137: ,FND_GLOBAL.USER_ID CREATED_BY
138: ,SYSDATE CREATION_DATE
139: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
140: ,NVL(HDRSTG.PO_REQUIRED,'N') PO_REQUIRED
141: ,HDRSTG.SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ
142: ,HDRSTG.PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
143: ,HDRSTG.DATE_APPROVED DATE_APPROVED

Line 148: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

144: ,HDRSTG.DATE_CANCELED DATE_CANCELLED
145: ,HDRSTG.DATE_SIGNED DATE_SIGNED
146: ,HDRSTG.START_DATE START_DATE
147: ,HDRSTG.END_DATE END_DATE
148: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
149: ,SYSDATE LAST_UPDATE_DATE
150: ,515 APPLICATION_ID
151: ,HDRSTG.SOURCE ORIG_SYSTEM_SOURCE_CODE
152: ,null ORIG_SYSTEM_ID1

Line 155: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID

151: ,HDRSTG.SOURCE ORIG_SYSTEM_SOURCE_CODE
152: ,null ORIG_SYSTEM_ID1
153: ,HDRSTG.DOCUMENT ORIG_SYSTEM_REFERENCE1
154: ,515 PROGRAM_APPLICATION_ID
155: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID
156: ,SYSDATE PROGRAM_UPDATE_DATE
157: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID
158: ,HDRSTG.PRICE_LIST_ID PRICE_LIST_ID
159: ,HDRSTG.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE

Line 157: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID

153: ,HDRSTG.DOCUMENT ORIG_SYSTEM_REFERENCE1
154: ,515 PROGRAM_APPLICATION_ID
155: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID
156: ,SYSDATE PROGRAM_UPDATE_DATE
157: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID
158: ,HDRSTG.PRICE_LIST_ID PRICE_LIST_ID
159: ,HDRSTG.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
160: ,HDRSTG.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
161: ,HDRSTG.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE

Line 338: ,FND_GLOBAL.USER_ID CREATED_BY

334: ,HDRSTG.KNOWN_AS KNOWN_AS
335: ,HDRSTG.AGREEMENT_ID AGREEMENT_ID
336: ,HDRSTG.APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID
337: ,1 OBJECT_VERSION_NUMBER
338: ,FND_GLOBAL.USER_ID CREATED_BY
339: ,SYSDATE CREATION_DATE
340: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
341: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
342: ,SYSDATE LAST_UPDATE_DATE

Line 340: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

336: ,HDRSTG.APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID
337: ,1 OBJECT_VERSION_NUMBER
338: ,FND_GLOBAL.USER_ID CREATED_BY
339: ,SYSDATE CREATION_DATE
340: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
341: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
342: ,SYSDATE LAST_UPDATE_DATE
343: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
344: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 341: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

337: ,1 OBJECT_VERSION_NUMBER
338: ,FND_GLOBAL.USER_ID CREATED_BY
339: ,SYSDATE CREATION_DATE
340: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
341: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
342: ,SYSDATE LAST_UPDATE_DATE
343: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
344: ,OKC_K_HEADERS_ALL_B OKCHDRB
345: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 532: ,FND_GLOBAL.USER_ID CREATED_BY

528: ,HDRSTG.SUMMARY_TRANSACTIONS SUMMARY_TRANSACTIONS
529: ,HDRSTG.SERVICE_CHARGES_PO_NUMBER SERVICE_CHARGES_PO_NUMBER
530: ,HDRSTG.SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED
531: ,1 OBJECT_VERSION_NUMBER
532: ,FND_GLOBAL.USER_ID CREATED_BY
533: ,SYSDATE CREATION_DATE
534: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
535: ,SYSDATE LAST_UPDATE_DATE
536: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 534: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

530: ,HDRSTG.SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED
531: ,1 OBJECT_VERSION_NUMBER
532: ,FND_GLOBAL.USER_ID CREATED_BY
533: ,SYSDATE CREATION_DATE
534: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
535: ,SYSDATE LAST_UPDATE_DATE
536: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
537: ,HDRSTG.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
538: ,HDRSTG.FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE

Line 536: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

532: ,FND_GLOBAL.USER_ID CREATED_BY
533: ,SYSDATE CREATION_DATE
534: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
535: ,SYSDATE LAST_UPDATE_DATE
536: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
537: ,HDRSTG.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
538: ,HDRSTG.FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE
539: ,null CREDIT_CARD_TRXN_EXTENSION_ID
540: ,HDRSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER

Line 663: ,FND_GLOBAL.USER_ID CREATED_BY

659: ,1 OBJECT_VERSION_NUMBER
660: ,HDRSTG.CONTRACT_GROUP_ID CONTRACT_GROUP_ID
661: ,OKCHDRB.ID INCLUDED_CHR_ID
662: ,HDRSTG.CATEGORY CATEGORY
663: ,FND_GLOBAL.USER_ID CREATED_BY
664: ,SYSDATE CREATION_DATE
665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
666: ,SYSDATE LAST_UPDATE_DATE
667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

661: ,OKCHDRB.ID INCLUDED_CHR_ID
662: ,HDRSTG.CATEGORY CATEGORY
663: ,FND_GLOBAL.USER_ID CREATED_BY
664: ,SYSDATE CREATION_DATE
665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
666: ,SYSDATE LAST_UPDATE_DATE
667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
668:
669: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

663: ,FND_GLOBAL.USER_ID CREATED_BY
664: ,SYSDATE CREATION_DATE
665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
666: ,SYSDATE LAST_UPDATE_DATE
667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
668:
669: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
670: ,OKC_K_HEADERS_ALL_B OKCHDRB
671: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 828: ,FND_GLOBAL.USER_ID CREATED_BY

824: ,(CASE WHEN HDRSTG.CATEGORY IN ('SERVICE','WARRANTY') THEN 'CUSTOMER'
825: WHEN HDRSTG.CATEGORY IN ('SUBSCRIPTION') THEN 'SUBSCRIBER'
826: END) RLE_CODE_CUST
827: ,1 OBJECT_VERSION_NUMBER
828: ,FND_GLOBAL.USER_ID CREATED_BY
829: ,SYSDATE CREATION_DATE
830: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
831: ,SYSDATE LAST_UPDATE_DATE
832:

Line 830: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

826: END) RLE_CODE_CUST
827: ,1 OBJECT_VERSION_NUMBER
828: ,FND_GLOBAL.USER_ID CREATED_BY
829: ,SYSDATE CREATION_DATE
830: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
831: ,SYSDATE LAST_UPDATE_DATE
832:
833: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
834: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 892: ,FND_GLOBAL.USER_ID CREATED_BY

888: WHEN HDRSTG.CATEGORY IN ('SUBSCRIPTION') THEN 'SUBSCRIBER'
889: END) RLE_CODE
890: ,1 OBJECT_VERSION_NUMBER
891: ,'OKX_PARTY' JTOT_OBJECT1_CODE
892: ,FND_GLOBAL.USER_ID CREATED_BY
893: ,SYSDATE CREATION_DATE
894: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
895: ,SYSDATE LAST_UPDATE_DATE
896: ,USERENV('LANG') LANGUAGE

Line 894: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

890: ,1 OBJECT_VERSION_NUMBER
891: ,'OKX_PARTY' JTOT_OBJECT1_CODE
892: ,FND_GLOBAL.USER_ID CREATED_BY
893: ,SYSDATE CREATION_DATE
894: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
895: ,SYSDATE LAST_UPDATE_DATE
896: ,USERENV('LANG') LANGUAGE
897: ,USERENV('LANG') SOURCE_LANG
898: ,'N' SFWT_FLAG

Line 900: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

896: ,USERENV('LANG') LANGUAGE
897: ,USERENV('LANG') SOURCE_LANG
898: ,'N' SFWT_FLAG
899: ,null COGNOMEN
900: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
901: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
902: ,OKC_K_HEADERS_ALL_B OKCHDRB
903: ,OKC_K_LINES_B OKCLINB
904: ,OKS_LINES_INTERFACE LININT

Line 952: ,FND_GLOBAL.USER_ID CREATED_BY

948: SELECT OKCPTY.ID OKCKPTYRL_ID
949: ,USERENV('LANG') LANGUAGE
950: ,USERENV('LANG') SOURCE_LANG
951: ,'N' SFWT_FLAG
952: ,FND_GLOBAL.USER_ID CREATED_BY
953: ,SYSDATE CREATION_DATE
954: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
955: ,SYSDATE LAST_UPDATE_DATE
956: ,null COGNOMEN

Line 954: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

950: ,USERENV('LANG') SOURCE_LANG
951: ,'N' SFWT_FLAG
952: ,FND_GLOBAL.USER_ID CREATED_BY
953: ,SYSDATE CREATION_DATE
954: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
955: ,SYSDATE LAST_UPDATE_DATE
956: ,null COGNOMEN
957: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
958:

Line 957: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

953: ,SYSDATE CREATION_DATE
954: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
955: ,SYSDATE LAST_UPDATE_DATE
956: ,null COGNOMEN
957: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
958:
959: FROM OKC_K_PARTY_ROLES_B OKCPTY
960: ,OKC_K_HEADERS_ALL_B OKCHDRB
961: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1049: ,FND_GLOBAL.USER_ID CREATED_BY

1045: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1046: ,HDRSTG.CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID
1047: ,OKCHDRB.ID DNZ_CHR_ID
1048: ,1 OBJECT_VERSION_NUMBER
1049: ,FND_GLOBAL.USER_ID CREATED_BY
1050: ,SYSDATE CREATION_DATE
1051: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1052: ,SYSDATE LAST_UPDATE_DATE
1053: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1051: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1047: ,OKCHDRB.ID DNZ_CHR_ID
1048: ,1 OBJECT_VERSION_NUMBER
1049: ,FND_GLOBAL.USER_ID CREATED_BY
1050: ,SYSDATE CREATION_DATE
1051: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1052: ,SYSDATE LAST_UPDATE_DATE
1053: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1054: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1055: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1108: ,FND_GLOBAL.USER_ID CREATED_BY

1104: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1105: ,OKCHDRB.ID DNZ_CHR_ID
1106: ,1 OBJECT_VERSION_NUMBER
1107: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID
1108: ,FND_GLOBAL.USER_ID CREATED_BY
1109: ,SYSDATE CREATION_DATE
1110: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1111: ,SYSDATE LAST_UPDATE_DATE
1112: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1110: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1106: ,1 OBJECT_VERSION_NUMBER
1107: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID
1108: ,FND_GLOBAL.USER_ID CREATED_BY
1109: ,SYSDATE CREATION_DATE
1110: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1111: ,SYSDATE LAST_UPDATE_DATE
1112: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1113: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1114: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1202: ,FND_GLOBAL.USER_ID CREATED_BY

1198: ,(CASE WHEN LINSTG.CUSTOMER_BILLING_CONTACT_ID IS NOT NULL THEN 'OKX_CONTBILL'
1199: WHEN LINSTG.CUSTOMER_SHIPPING_CONTACT_ID IS NOT NULL THEN 'OKX_CONTSHIP'
1200: END ) JTOT_OBJECT1_CODE
1201: ,1 OBJECT_VERSION_NUMBER
1202: ,FND_GLOBAL.USER_ID CREATED_BY
1203: ,SYSDATE CREATION_DATE
1204: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1205: ,SYSDATE LAST_UPDATE_DATE
1206: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1204: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1200: END ) JTOT_OBJECT1_CODE
1201: ,1 OBJECT_VERSION_NUMBER
1202: ,FND_GLOBAL.USER_ID CREATED_BY
1203: ,SYSDATE CREATION_DATE
1204: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1205: ,SYSDATE LAST_UPDATE_DATE
1206: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1207:
1208: FROM OKS_INT_LINE_STG_TEMP LINSTG

Line 1206: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1202: ,FND_GLOBAL.USER_ID CREATED_BY
1203: ,SYSDATE CREATION_DATE
1204: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1205: ,SYSDATE LAST_UPDATE_DATE
1206: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1207:
1208: FROM OKS_INT_LINE_STG_TEMP LINSTG
1209: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1210: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1310: ,FND_GLOBAL.USER_ID CREATED_BY

1306: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID
1307: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID
1308: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1309: ,1 OBJECT_VERSION_NUMBER
1310: ,FND_GLOBAL.USER_ID CREATED_BY
1311: ,SYSDATE CREATION_DATE
1312: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1313: ,SYSDATE LAST_UPDATE_DATE
1314: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1312: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1308: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1309: ,1 OBJECT_VERSION_NUMBER
1310: ,FND_GLOBAL.USER_ID CREATED_BY
1311: ,SYSDATE CREATION_DATE
1312: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1313: ,SYSDATE LAST_UPDATE_DATE
1314: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1315:
1316: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG

Line 1366: ,FND_GLOBAL.USER_ID CREATED_BY

1362: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID
1363: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID
1364: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1365: ,1 OBJECT_VERSION_NUMBER
1366: ,FND_GLOBAL.USER_ID CREATED_BY
1367: ,SYSDATE CREATION_DATE
1368: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1369: ,SYSDATE LAST_UPDATE_DATE
1370: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1368: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1364: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1365: ,1 OBJECT_VERSION_NUMBER
1366: ,FND_GLOBAL.USER_ID CREATED_BY
1367: ,SYSDATE CREATION_DATE
1368: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1369: ,SYSDATE LAST_UPDATE_DATE
1370: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1371:
1372: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG

Line 1520: ,FND_GLOBAL.USER_ID CREATED_BY

1516: ,OLSTG.STATUS_CODE STATUS_CODE
1517: ,OLSTG.CANCELLATION_REASON CANCELLATION_REASON
1518: ,OLSTG.LSE_ID LSE_ID
1519: ,1 OBJECT_VERSION_NUMBER
1520: ,FND_GLOBAL.USER_ID CREATED_BY
1521: ,SYSDATE CREATION_DATE
1522: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1523: ,SYSDATE LAST_UPDATE_DATE
1524:

Line 1522: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1518: ,OLSTG.LSE_ID LSE_ID
1519: ,1 OBJECT_VERSION_NUMBER
1520: ,FND_GLOBAL.USER_ID CREATED_BY
1521: ,SYSDATE CREATION_DATE
1522: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1523: ,SYSDATE LAST_UPDATE_DATE
1524:
1525: ,OHSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
1526: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1526: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1522: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1523: ,SYSDATE LAST_UPDATE_DATE
1524:
1525: ,OHSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
1526: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1527: ,OLSTG.START_DATE START_DATE
1528: ,OLSTG.END_DATE END_DATE
1529: ,OHSTG.CATEGORY CATEGORY
1530: ,null ORIG_SYSTEM_SOURCE_CODE

Line 1663: ,FND_GLOBAL.USER_ID CREATED_BY

1659: SELECT OKCLINB.ID OKCLINB_ID
1660: ,USERENV('LANG') LANGUAGE
1661: ,USERENV('LANG') SOURCE_LANG
1662: ,OLSTG.LINE_REFERENCE COGNOMEN
1663: ,FND_GLOBAL.USER_ID CREATED_BY
1664: ,SYSDATE CREATION_DATE
1665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1666: ,SYSDATE LAST_UPDATE_DATE
1667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1661: ,USERENV('LANG') SOURCE_LANG
1662: ,OLSTG.LINE_REFERENCE COGNOMEN
1663: ,FND_GLOBAL.USER_ID CREATED_BY
1664: ,SYSDATE CREATION_DATE
1665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1666: ,SYSDATE LAST_UPDATE_DATE
1667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1668: ,okc_p_util.raw_to_number(sys_guid()) OKCKITEM_ID
1669: ,OKCLINB.ID CLE_ID

Line 1667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1663: ,FND_GLOBAL.USER_ID CREATED_BY
1664: ,SYSDATE CREATION_DATE
1665: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1666: ,SYSDATE LAST_UPDATE_DATE
1667: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1668: ,okc_p_util.raw_to_number(sys_guid()) OKCKITEM_ID
1669: ,OKCLINB.ID CLE_ID
1670: ,OKCHDRB.ID DNZ_CHR_ID
1671: ,null CHR_ID

Line 1834: ,FND_GLOBAL.USER_ID CREATED_BY

1830: ,OLSTG.PO_REQUIRED PO_REQUIRED
1831: ,OLSTG.PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
1832: ,OLSTG.PRINT_INVOICE PRINT_INVOICE
1833: ,OLSTG.TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
1834: ,FND_GLOBAL.USER_ID CREATED_BY
1835: ,SYSDATE CREATION_DATE
1836: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1837: ,SYSDATE LAST_UPDATE_DATE
1838: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1836: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1832: ,OLSTG.PRINT_INVOICE PRINT_INVOICE
1833: ,OLSTG.TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
1834: ,FND_GLOBAL.USER_ID CREATED_BY
1835: ,SYSDATE CREATION_DATE
1836: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1837: ,SYSDATE LAST_UPDATE_DATE
1838: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1839: ,OLSTG.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
1840: ,OLSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER

Line 1838: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1834: ,FND_GLOBAL.USER_ID CREATED_BY
1835: ,SYSDATE CREATION_DATE
1836: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1837: ,SYSDATE LAST_UPDATE_DATE
1838: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1839: ,OLSTG.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
1840: ,OLSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER
1841: ,OLSTG.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
1842: ,OLSTG.REFERENCE_TEMPLATE_ID COVERAGE_ID

Line 1938: ,FND_GLOBAL.USER_ID CREATED_BY

1934:
1935: SELECT OKSLINB.ID OKSLINB_ID
1936: ,USERENV('LANG') LANGUAGE
1937: ,USERENV('LANG') SOURCE_LANG
1938: ,FND_GLOBAL.USER_ID CREATED_BY
1939: ,SYSDATE CREATION_DATE
1940: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1941: ,SYSDATE LAST_UPDATE_DATE
1942: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1940: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1936: ,USERENV('LANG') LANGUAGE
1937: ,USERENV('LANG') SOURCE_LANG
1938: ,FND_GLOBAL.USER_ID CREATED_BY
1939: ,SYSDATE CREATION_DATE
1940: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1941: ,SYSDATE LAST_UPDATE_DATE
1942: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1943: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1944: FROM OKS_INT_LINE_STG_TEMP OLSTG

Line 1942: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1938: ,FND_GLOBAL.USER_ID CREATED_BY
1939: ,SYSDATE CREATION_DATE
1940: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1941: ,SYSDATE LAST_UPDATE_DATE
1942: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1943: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1944: FROM OKS_INT_LINE_STG_TEMP OLSTG
1945: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1946: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2012: ,FND_GLOBAL.USER_ID CREATED_BY

2008: ,SUB_HDR.FREQUENCY FREQUENCY
2009: ,SUB_HDR.FULFILLMENT_CHANNEL FULFILLMENT_CHANNEL
2010: ,SUB_HDR.OFFSET OFFSET
2011: ,1 OBJECT_VERSION_NUMBER
2012: ,FND_GLOBAL.USER_ID CREATED_BY
2013: ,SYSDATE CREATION_DATE
2014: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2015: ,SYSDATE LAST_UPDATE_DATE
2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2014: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2010: ,SUB_HDR.OFFSET OFFSET
2011: ,1 OBJECT_VERSION_NUMBER
2012: ,FND_GLOBAL.USER_ID CREATED_BY
2013: ,SYSDATE CREATION_DATE
2014: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2015: ,SYSDATE LAST_UPDATE_DATE
2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2017: FROM OKC_K_LINES_B OKCLINB
2018: ,OKS_INT_LINE_STG_TEMP OLSTG

Line 2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2012: ,FND_GLOBAL.USER_ID CREATED_BY
2013: ,SYSDATE CREATION_DATE
2014: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2015: ,SYSDATE LAST_UPDATE_DATE
2016: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2017: FROM OKC_K_LINES_B OKCLINB
2018: ,OKS_INT_LINE_STG_TEMP OLSTG
2019: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2020: ,OKS_SUBSCR_HEADER_B SUB_HDR

Line 2069: ,FND_GLOBAL.USER_ID CREATED_BY

2065: ,USERENV('LANG') LANGUAGE
2066: ,USERENV('LANG') SOURCE_LANG
2067: ,'N' SFWT_FLAG
2068: ,SUB_HDR_TL.COMMENTS COMMENTS
2069: ,FND_GLOBAL.USER_ID CREATED_BY
2070: ,SYSDATE CREATION_DATE
2071: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2072: ,SYSDATE LAST_UPDATE_DATE
2073: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2071: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2067: ,'N' SFWT_FLAG
2068: ,SUB_HDR_TL.COMMENTS COMMENTS
2069: ,FND_GLOBAL.USER_ID CREATED_BY
2070: ,SYSDATE CREATION_DATE
2071: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2072: ,SYSDATE LAST_UPDATE_DATE
2073: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2074:
2075: FROM OKC_K_LINES_B OKCLINB

Line 2073: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2069: ,FND_GLOBAL.USER_ID CREATED_BY
2070: ,SYSDATE CREATION_DATE
2071: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2072: ,SYSDATE LAST_UPDATE_DATE
2073: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2074:
2075: FROM OKC_K_LINES_B OKCLINB
2076: ,OKS_INT_LINE_STG_TEMP OLSTG
2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2213: ,FND_GLOBAL.USER_ID CREATED_BY

2209: WHEN OCLVLSTG.COVERED_SYSTEM_ID IS NOT NULL THEN 11
2210: END) LSE_ID
2211: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
2212: ,1 OBJECT_VERSION_NUMBER
2213: ,FND_GLOBAL.USER_ID CREATED_BY
2214: ,SYSDATE CREATION_DATE
2215: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2216: ,SYSDATE LAST_UPDATE_DATE
2217: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2215: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2211: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
2212: ,1 OBJECT_VERSION_NUMBER
2213: ,FND_GLOBAL.USER_ID CREATED_BY
2214: ,SYSDATE CREATION_DATE
2215: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2216: ,SYSDATE LAST_UPDATE_DATE
2217: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2218: ,OCLI.SUBTOTAL SUBTOTAL
2219: ,(CASE WHEN OCLI.SUBTOTAL IS NOT NULL AND OCLI.SUBTOTAL > 0

Line 2217: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2213: ,FND_GLOBAL.USER_ID CREATED_BY
2214: ,SYSDATE CREATION_DATE
2215: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2216: ,SYSDATE LAST_UPDATE_DATE
2217: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2218: ,OCLI.SUBTOTAL SUBTOTAL
2219: ,(CASE WHEN OCLI.SUBTOTAL IS NOT NULL AND OCLI.SUBTOTAL > 0
2220: AND OCLI.QUANTITY_COVERED IS NOT NULL AND OCLI.QUANTITY_COVERED > 0
2221: THEN OCLI.SUBTOTAL/OCLI.QUANTITY_COVERED

Line 2301: ,FND_GLOBAL.USER_ID CREATED_BY

2297: ,OCLI.PRICE_UOM PRICE_UOM
2298: ,OCLI.TAX_AMOUNT TAX_AMOUNT
2299: ,'T' BILLING_SCHEDULE_TYPE
2300: ,1 OBJECT_VERSION_NUMBER
2301: ,FND_GLOBAL.USER_ID CREATED_BY
2302: ,SYSDATE CREATION_DATE
2303: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2304: ,SYSDATE LAST_UPDATE_DATE
2305: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2303: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2299: ,'T' BILLING_SCHEDULE_TYPE
2300: ,1 OBJECT_VERSION_NUMBER
2301: ,FND_GLOBAL.USER_ID CREATED_BY
2302: ,SYSDATE CREATION_DATE
2303: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2304: ,SYSDATE LAST_UPDATE_DATE
2305: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2306:
2307: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

Line 2305: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2301: ,FND_GLOBAL.USER_ID CREATED_BY
2302: ,SYSDATE CREATION_DATE
2303: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2304: ,SYSDATE LAST_UPDATE_DATE
2305: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2306:
2307: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2308: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2309: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2365: ,FND_GLOBAL.USER_ID CREATED_BY

2361: ,USERENV('LANG') LANGUAGE
2362: ,USERENV('LANG') SOURCE_LANG
2363: ,'S' OKS_SFWT_FLAG
2364: ,OCLI.INVOICE_TEXT INVOICE_TEXT
2365: ,FND_GLOBAL.USER_ID CREATED_BY
2366: ,SYSDATE CREATION_DATE
2367: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2368: ,SYSDATE LAST_UPDATE_DATE
2369: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2367: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2363: ,'S' OKS_SFWT_FLAG
2364: ,OCLI.INVOICE_TEXT INVOICE_TEXT
2365: ,FND_GLOBAL.USER_ID CREATED_BY
2366: ,SYSDATE CREATION_DATE
2367: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2368: ,SYSDATE LAST_UPDATE_DATE
2369: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2370:
2371: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

Line 2369: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2365: ,FND_GLOBAL.USER_ID CREATED_BY
2366: ,SYSDATE CREATION_DATE
2367: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2368: ,SYSDATE LAST_UPDATE_DATE
2369: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2370:
2371: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2372: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2373: ,OKC_K_HEADERS_aLL_B OKCHDRB

Line 2487: ,FND_GLOBAL.USER_ID CREATED_BY

2483: ,OCLI.QUANTITY_UOM UOM_CODE
2484: ,'N' EXCEPTION_YN
2485: ,OCLI.QUANTITY_COVERED NUMBER_OF_ITEMS
2486: ,1 OBJECT_VERSION_NUMBER
2487: ,FND_GLOBAL.USER_ID CREATED_BY
2488: ,SYSDATE CREATION_DATE
2489: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2490: ,SYSDATE LAST_UPDATE_DATE
2491: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2489: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2485: ,OCLI.QUANTITY_COVERED NUMBER_OF_ITEMS
2486: ,1 OBJECT_VERSION_NUMBER
2487: ,FND_GLOBAL.USER_ID CREATED_BY
2488: ,SYSDATE CREATION_DATE
2489: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2490: ,SYSDATE LAST_UPDATE_DATE
2491: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2492: ,USERENV('LANG') LANGUAGE
2493: ,USERENV('LANG') SOURCE_LANG

Line 2491: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2487: ,FND_GLOBAL.USER_ID CREATED_BY
2488: ,SYSDATE CREATION_DATE
2489: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2490: ,SYSDATE LAST_UPDATE_DATE
2491: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2492: ,USERENV('LANG') LANGUAGE
2493: ,USERENV('LANG') SOURCE_LANG
2494: ,'N' OKC_SFWT_FLAG
2495: ,OCLI.LINE_REFERENCE LINE_REFERENCE

Line 2594: ,FND_GLOBAL.USER_ID CREATED_BY

2590: ,OUSGCNTSTG.CANCELLATION_REASON CANCELLATION_REASON
2591: ,13 LSE_ID
2592: ,'N' EXCEPTION_YN
2593: ,1 OBJECT_VERSION_NUMBER
2594: ,FND_GLOBAL.USER_ID CREATED_BY
2595: ,SYSDATE CREATION_DATE
2596: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2597: ,SYSDATE LAST_UPDATE_DATE
2598: ,OUSGCNTSTG.SUBTOTAL SUBTOTAL

Line 2596: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2592: ,'N' EXCEPTION_YN
2593: ,1 OBJECT_VERSION_NUMBER
2594: ,FND_GLOBAL.USER_ID CREATED_BY
2595: ,SYSDATE CREATION_DATE
2596: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2597: ,SYSDATE LAST_UPDATE_DATE
2598: ,OUSGCNTSTG.SUBTOTAL SUBTOTAL
2599: ,'Y' PRICED_YN
2600: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE

Line 2714: ,FND_GLOBAL.USER_ID CREATED_BY

2710: ,NULL USAGE_PERIOD
2711: ,NULL USAGE_TYPE
2712: ,NULL UOM_QUANTIFIED
2713: ,OUSGCNTSTG.PRINT_INVOICE INV_PRINT_FLAG
2714: ,FND_GLOBAL.USER_ID CREATED_BY
2715: ,SYSDATE CREATION_DATE
2716: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2717: ,SYSDATE LAST_UPDATE_DATE
2718: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2716: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2712: ,NULL UOM_QUANTIFIED
2713: ,OUSGCNTSTG.PRINT_INVOICE INV_PRINT_FLAG
2714: ,FND_GLOBAL.USER_ID CREATED_BY
2715: ,SYSDATE CREATION_DATE
2716: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2717: ,SYSDATE LAST_UPDATE_DATE
2718: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2719: ,null ORIG_SYSTEM_SOURCE_CODE
2720: ,null ORIG_SYSTEM_ID1

Line 2718: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2714: ,FND_GLOBAL.USER_ID CREATED_BY
2715: ,SYSDATE CREATION_DATE
2716: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2717: ,SYSDATE LAST_UPDATE_DATE
2718: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2719: ,null ORIG_SYSTEM_SOURCE_CODE
2720: ,null ORIG_SYSTEM_ID1
2721: ,null ORIG_SYSTEM_REFERENCE1
2722: ,'T' BILLING_SCHEDULE_TYPE

Line 2830: ,FND_GLOBAL.USER_ID CREATED_BY

2826: SELECT OKCLINB_SUBLINE.ID OKCLINB_ID
2827: ,USERENV('LANG') LANGUAGE
2828: ,USERENV('LANG') SOURCE_LANG
2829: ,'N' SFWT_FLAG
2830: ,FND_GLOBAL.USER_ID CREATED_BY
2831: ,SYSDATE CREATION_DATE
2832: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2833: ,SYSDATE LAST_UPDATE_DATE
2834: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2832: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2828: ,USERENV('LANG') SOURCE_LANG
2829: ,'N' SFWT_FLAG
2830: ,FND_GLOBAL.USER_ID CREATED_BY
2831: ,SYSDATE CREATION_DATE
2832: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2833: ,SYSDATE LAST_UPDATE_DATE
2834: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2835: ,OUSGCNTSTG.LINE_REFERENCE COGNOMEN
2836: ,OKSLINB.ID OKSLINB_ID

Line 2834: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2830: ,FND_GLOBAL.USER_ID CREATED_BY
2831: ,SYSDATE CREATION_DATE
2832: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2833: ,SYSDATE LAST_UPDATE_DATE
2834: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2835: ,OUSGCNTSTG.LINE_REFERENCE COGNOMEN
2836: ,OKSLINB.ID OKSLINB_ID
2837: ,OUSGCNTINT.INVOICE_TEXT INVOICE_TEXT
2838: ,okc_p_util.raw_to_number(sys_guid()) OKCKITM_ID