APPS.OKS_IMPORT_INSERT dependencies on FND_GLOBAL

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

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

Line 142: ,FND_GLOBAL.USER_ID CREATED_BY

138: ,'N' DELETED_YN
139: ,'N' TEMPLATE_YN
140: ,'CYA' CHR_TYPE
141: ,1 OBJECT_VERSION_NUMBER
142: ,FND_GLOBAL.USER_ID CREATED_BY
143: ,SYSDATE CREATION_DATE
144: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
145: ,NVL(HDRSTG.PO_REQUIRED,'N') PO_REQUIRED
146: ,HDRSTG.SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ

Line 144: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

140: ,'CYA' CHR_TYPE
141: ,1 OBJECT_VERSION_NUMBER
142: ,FND_GLOBAL.USER_ID CREATED_BY
143: ,SYSDATE CREATION_DATE
144: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
145: ,NVL(HDRSTG.PO_REQUIRED,'N') PO_REQUIRED
146: ,HDRSTG.SERVICE_CHRG_PREPAY_REQ SERVICE_CHRG_PREPAY_REQ
147: ,HDRSTG.PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
148: ,HDRSTG.DATE_APPROVED DATE_APPROVED

Line 153: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

149: ,HDRSTG.DATE_CANCELED DATE_CANCELLED
150: ,HDRSTG.DATE_SIGNED DATE_SIGNED
151: ,HDRSTG.START_DATE START_DATE
152: ,HDRSTG.END_DATE END_DATE
153: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
154: ,SYSDATE LAST_UPDATE_DATE
155: ,515 APPLICATION_ID
156: ,HDRSTG.SOURCE ORIG_SYSTEM_SOURCE_CODE
157: ,null ORIG_SYSTEM_ID1

Line 160: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID

156: ,HDRSTG.SOURCE ORIG_SYSTEM_SOURCE_CODE
157: ,null ORIG_SYSTEM_ID1
158: ,HDRSTG.DOCUMENT ORIG_SYSTEM_REFERENCE1
159: ,515 PROGRAM_APPLICATION_ID
160: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID
161: ,SYSDATE PROGRAM_UPDATE_DATE
162: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID
163: ,HDRSTG.PRICE_LIST_ID PRICE_LIST_ID
164: ,HDRSTG.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE

Line 162: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID

158: ,HDRSTG.DOCUMENT ORIG_SYSTEM_REFERENCE1
159: ,515 PROGRAM_APPLICATION_ID
160: ,FND_GLOBAL.CONC_PROGRAM_ID PROGRAM_ID
161: ,SYSDATE PROGRAM_UPDATE_DATE
162: ,FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID
163: ,HDRSTG.PRICE_LIST_ID PRICE_LIST_ID
164: ,HDRSTG.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
165: ,HDRSTG.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
166: ,HDRSTG.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE

Line 343: ,FND_GLOBAL.USER_ID CREATED_BY

339: ,HDRSTG.KNOWN_AS KNOWN_AS
340: ,HDRSTG.AGREEMENT_ID AGREEMENT_ID
341: ,HDRSTG.APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID
342: ,1 OBJECT_VERSION_NUMBER
343: ,FND_GLOBAL.USER_ID CREATED_BY
344: ,SYSDATE CREATION_DATE
345: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
346: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
347: ,SYSDATE LAST_UPDATE_DATE

Line 345: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

341: ,HDRSTG.APPROVAL_PROCESS_ID APPROVAL_PROCESS_ID
342: ,1 OBJECT_VERSION_NUMBER
343: ,FND_GLOBAL.USER_ID CREATED_BY
344: ,SYSDATE CREATION_DATE
345: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
346: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
347: ,SYSDATE LAST_UPDATE_DATE
348: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
349: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 346: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

342: ,1 OBJECT_VERSION_NUMBER
343: ,FND_GLOBAL.USER_ID CREATED_BY
344: ,SYSDATE CREATION_DATE
345: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
346: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
347: ,SYSDATE LAST_UPDATE_DATE
348: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
349: ,OKC_K_HEADERS_ALL_B OKCHDRB
350: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 537: ,FND_GLOBAL.USER_ID CREATED_BY

533: ,HDRSTG.SUMMARY_TRANSACTIONS SUMMARY_TRANSACTIONS
534: ,HDRSTG.SERVICE_CHARGES_PO_NUMBER SERVICE_CHARGES_PO_NUMBER
535: ,HDRSTG.SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED
536: ,1 OBJECT_VERSION_NUMBER
537: ,FND_GLOBAL.USER_ID CREATED_BY
538: ,SYSDATE CREATION_DATE
539: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
540: ,SYSDATE LAST_UPDATE_DATE
541: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 539: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

535: ,HDRSTG.SERVICE_CHARGES_PO_REQUIRED SERVICE_CHARGES_PO_REQUIRED
536: ,1 OBJECT_VERSION_NUMBER
537: ,FND_GLOBAL.USER_ID CREATED_BY
538: ,SYSDATE CREATION_DATE
539: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
540: ,SYSDATE LAST_UPDATE_DATE
541: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
542: ,HDRSTG.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
543: ,HDRSTG.FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE

Line 541: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

537: ,FND_GLOBAL.USER_ID CREATED_BY
538: ,SYSDATE CREATION_DATE
539: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
540: ,SYSDATE LAST_UPDATE_DATE
541: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
542: ,HDRSTG.FOLLOW_UP_ACTION FOLLOW_UP_ACTION
543: ,HDRSTG.FOLLOW_UP_DUE_DATE FOLLOW_UP_DUE_DATE
544: ,null CREDIT_CARD_TRXN_EXTENSION_ID
545: ,HDRSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER

Line 668: ,FND_GLOBAL.USER_ID CREATED_BY

664: ,1 OBJECT_VERSION_NUMBER
665: ,HDRSTG.CONTRACT_GROUP_ID CONTRACT_GROUP_ID
666: ,OKCHDRB.ID INCLUDED_CHR_ID
667: ,HDRSTG.CATEGORY CATEGORY
668: ,FND_GLOBAL.USER_ID CREATED_BY
669: ,SYSDATE CREATION_DATE
670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
671: ,SYSDATE LAST_UPDATE_DATE
672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

666: ,OKCHDRB.ID INCLUDED_CHR_ID
667: ,HDRSTG.CATEGORY CATEGORY
668: ,FND_GLOBAL.USER_ID CREATED_BY
669: ,SYSDATE CREATION_DATE
670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
671: ,SYSDATE LAST_UPDATE_DATE
672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
673:
674: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

668: ,FND_GLOBAL.USER_ID CREATED_BY
669: ,SYSDATE CREATION_DATE
670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
671: ,SYSDATE LAST_UPDATE_DATE
672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
673:
674: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
675: ,OKC_K_HEADERS_ALL_B OKCHDRB
676: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 833: ,FND_GLOBAL.USER_ID CREATED_BY

829: ,(CASE WHEN HDRSTG.CATEGORY IN ('SERVICE','WARRANTY') THEN 'CUSTOMER'
830: WHEN HDRSTG.CATEGORY IN ('SUBSCRIPTION') THEN 'SUBSCRIBER'
831: END) RLE_CODE_CUST
832: ,1 OBJECT_VERSION_NUMBER
833: ,FND_GLOBAL.USER_ID CREATED_BY
834: ,SYSDATE CREATION_DATE
835: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
836: ,SYSDATE LAST_UPDATE_DATE
837:

Line 835: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

831: END) RLE_CODE_CUST
832: ,1 OBJECT_VERSION_NUMBER
833: ,FND_GLOBAL.USER_ID CREATED_BY
834: ,SYSDATE CREATION_DATE
835: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
836: ,SYSDATE LAST_UPDATE_DATE
837:
838: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
839: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 897: ,FND_GLOBAL.USER_ID CREATED_BY

893: WHEN HDRSTG.CATEGORY IN ('SUBSCRIPTION') THEN 'SUBSCRIBER'
894: END) RLE_CODE
895: ,1 OBJECT_VERSION_NUMBER
896: ,'OKX_PARTY' JTOT_OBJECT1_CODE
897: ,FND_GLOBAL.USER_ID CREATED_BY
898: ,SYSDATE CREATION_DATE
899: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
900: ,SYSDATE LAST_UPDATE_DATE
901: ,USERENV('LANG') LANGUAGE

Line 899: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

895: ,1 OBJECT_VERSION_NUMBER
896: ,'OKX_PARTY' JTOT_OBJECT1_CODE
897: ,FND_GLOBAL.USER_ID CREATED_BY
898: ,SYSDATE CREATION_DATE
899: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
900: ,SYSDATE LAST_UPDATE_DATE
901: ,USERENV('LANG') LANGUAGE
902: ,USERENV('LANG') SOURCE_LANG
903: ,'N' SFWT_FLAG

Line 905: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

901: ,USERENV('LANG') LANGUAGE
902: ,USERENV('LANG') SOURCE_LANG
903: ,'N' SFWT_FLAG
904: ,null COGNOMEN
905: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
906: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
907: ,OKC_K_HEADERS_ALL_B OKCHDRB
908: ,OKC_K_LINES_B OKCLINB
909: ,OKS_LINES_INTERFACE LININT

Line 957: ,FND_GLOBAL.USER_ID CREATED_BY

953: SELECT OKCPTY.ID OKCKPTYRL_ID
954: ,USERENV('LANG') LANGUAGE
955: ,USERENV('LANG') SOURCE_LANG
956: ,'N' SFWT_FLAG
957: ,FND_GLOBAL.USER_ID CREATED_BY
958: ,SYSDATE CREATION_DATE
959: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
960: ,SYSDATE LAST_UPDATE_DATE
961: ,null COGNOMEN

Line 959: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

955: ,USERENV('LANG') SOURCE_LANG
956: ,'N' SFWT_FLAG
957: ,FND_GLOBAL.USER_ID CREATED_BY
958: ,SYSDATE CREATION_DATE
959: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
960: ,SYSDATE LAST_UPDATE_DATE
961: ,null COGNOMEN
962: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
963:

Line 962: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

958: ,SYSDATE CREATION_DATE
959: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
960: ,SYSDATE LAST_UPDATE_DATE
961: ,null COGNOMEN
962: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
963:
964: FROM OKC_K_PARTY_ROLES_B OKCPTY
965: ,OKC_K_HEADERS_ALL_B OKCHDRB
966: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1054: ,FND_GLOBAL.USER_ID CREATED_BY

1050: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1051: ,HDRSTG.CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID
1052: ,OKCHDRB.ID DNZ_CHR_ID
1053: ,1 OBJECT_VERSION_NUMBER
1054: ,FND_GLOBAL.USER_ID CREATED_BY
1055: ,SYSDATE CREATION_DATE
1056: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1057: ,SYSDATE LAST_UPDATE_DATE
1058: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1056: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1052: ,OKCHDRB.ID DNZ_CHR_ID
1053: ,1 OBJECT_VERSION_NUMBER
1054: ,FND_GLOBAL.USER_ID CREATED_BY
1055: ,SYSDATE CREATION_DATE
1056: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1057: ,SYSDATE LAST_UPDATE_DATE
1058: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1059: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1060: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1113: ,FND_GLOBAL.USER_ID CREATED_BY

1109: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1110: ,OKCHDRB.ID DNZ_CHR_ID
1111: ,1 OBJECT_VERSION_NUMBER
1112: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID
1113: ,FND_GLOBAL.USER_ID CREATED_BY
1114: ,SYSDATE CREATION_DATE
1115: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1116: ,SYSDATE LAST_UPDATE_DATE
1117: FROM OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1115: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1111: ,1 OBJECT_VERSION_NUMBER
1112: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID
1113: ,FND_GLOBAL.USER_ID CREATED_BY
1114: ,SYSDATE CREATION_DATE
1115: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1116: ,SYSDATE LAST_UPDATE_DATE
1117: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1118: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1119: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1207: ,FND_GLOBAL.USER_ID CREATED_BY

1203: ,(CASE WHEN LINSTG.CUSTOMER_BILLING_CONTACT_ID IS NOT NULL THEN 'OKX_CONTBILL'
1204: WHEN LINSTG.CUSTOMER_SHIPPING_CONTACT_ID IS NOT NULL THEN 'OKX_CONTSHIP'
1205: END ) JTOT_OBJECT1_CODE
1206: ,1 OBJECT_VERSION_NUMBER
1207: ,FND_GLOBAL.USER_ID CREATED_BY
1208: ,SYSDATE CREATION_DATE
1209: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1210: ,SYSDATE LAST_UPDATE_DATE
1211: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1209: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1205: END ) JTOT_OBJECT1_CODE
1206: ,1 OBJECT_VERSION_NUMBER
1207: ,FND_GLOBAL.USER_ID CREATED_BY
1208: ,SYSDATE CREATION_DATE
1209: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1210: ,SYSDATE LAST_UPDATE_DATE
1211: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1212:
1213: FROM OKS_INT_LINE_STG_TEMP LINSTG

Line 1211: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1207: ,FND_GLOBAL.USER_ID CREATED_BY
1208: ,SYSDATE CREATION_DATE
1209: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1210: ,SYSDATE LAST_UPDATE_DATE
1211: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1212:
1213: FROM OKS_INT_LINE_STG_TEMP LINSTG
1214: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1215: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1315: ,FND_GLOBAL.USER_ID CREATED_BY

1311: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID
1312: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID
1313: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1314: ,1 OBJECT_VERSION_NUMBER
1315: ,FND_GLOBAL.USER_ID CREATED_BY
1316: ,SYSDATE CREATION_DATE
1317: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1318: ,SYSDATE LAST_UPDATE_DATE
1319: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1317: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1313: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1314: ,1 OBJECT_VERSION_NUMBER
1315: ,FND_GLOBAL.USER_ID CREATED_BY
1316: ,SYSDATE CREATION_DATE
1317: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1318: ,SYSDATE LAST_UPDATE_DATE
1319: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1320:
1321: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG

Line 1371: ,FND_GLOBAL.USER_ID CREATED_BY

1367: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID
1368: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID
1369: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1370: ,1 OBJECT_VERSION_NUMBER
1371: ,FND_GLOBAL.USER_ID CREATED_BY
1372: ,SYSDATE CREATION_DATE
1373: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1374: ,SYSDATE LAST_UPDATE_DATE
1375: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1373: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1369: ,OKSCRSTG.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID2 -- need to confirm what could be the value
1370: ,1 OBJECT_VERSION_NUMBER
1371: ,FND_GLOBAL.USER_ID CREATED_BY
1372: ,SYSDATE CREATION_DATE
1373: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1374: ,SYSDATE LAST_UPDATE_DATE
1375: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1376:
1377: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG

Line 1525: ,FND_GLOBAL.USER_ID CREATED_BY

1521: ,OLSTG.STATUS_CODE STATUS_CODE
1522: ,OLSTG.CANCELLATION_REASON CANCELLATION_REASON
1523: ,OLSTG.LSE_ID LSE_ID
1524: ,1 OBJECT_VERSION_NUMBER
1525: ,FND_GLOBAL.USER_ID CREATED_BY
1526: ,SYSDATE CREATION_DATE
1527: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1528: ,SYSDATE LAST_UPDATE_DATE
1529:

Line 1527: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1523: ,OLSTG.LSE_ID LSE_ID
1524: ,1 OBJECT_VERSION_NUMBER
1525: ,FND_GLOBAL.USER_ID CREATED_BY
1526: ,SYSDATE CREATION_DATE
1527: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1528: ,SYSDATE LAST_UPDATE_DATE
1529:
1530: ,OHSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
1531: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1531: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1527: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1528: ,SYSDATE LAST_UPDATE_DATE
1529:
1530: ,OHSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
1531: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1532: ,OLSTG.START_DATE START_DATE
1533: ,OLSTG.END_DATE END_DATE
1534: ,OHSTG.CATEGORY CATEGORY
1535: ,null ORIG_SYSTEM_SOURCE_CODE

Line 1668: ,FND_GLOBAL.USER_ID CREATED_BY

1664: SELECT OKCLINB.ID OKCLINB_ID
1665: ,USERENV('LANG') LANGUAGE
1666: ,USERENV('LANG') SOURCE_LANG
1667: ,OLSTG.LINE_REFERENCE COGNOMEN
1668: ,FND_GLOBAL.USER_ID CREATED_BY
1669: ,SYSDATE CREATION_DATE
1670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1671: ,SYSDATE LAST_UPDATE_DATE
1672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1666: ,USERENV('LANG') SOURCE_LANG
1667: ,OLSTG.LINE_REFERENCE COGNOMEN
1668: ,FND_GLOBAL.USER_ID CREATED_BY
1669: ,SYSDATE CREATION_DATE
1670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1671: ,SYSDATE LAST_UPDATE_DATE
1672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1673: ,okc_p_util.raw_to_number(sys_guid()) OKCKITEM_ID
1674: ,OKCLINB.ID CLE_ID

Line 1672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1668: ,FND_GLOBAL.USER_ID CREATED_BY
1669: ,SYSDATE CREATION_DATE
1670: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1671: ,SYSDATE LAST_UPDATE_DATE
1672: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1673: ,okc_p_util.raw_to_number(sys_guid()) OKCKITEM_ID
1674: ,OKCLINB.ID CLE_ID
1675: ,OKCHDRB.ID DNZ_CHR_ID
1676: ,null CHR_ID

Line 1842: ,FND_GLOBAL.USER_ID CREATED_BY

1838: ,OLSTG.PO_REQUIRED PO_REQUIRED
1839: ,OLSTG.PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
1840: ,OLSTG.PRINT_INVOICE PRINT_INVOICE
1841: ,OLSTG.TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
1842: ,FND_GLOBAL.USER_ID CREATED_BY
1843: ,SYSDATE CREATION_DATE
1844: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1845: ,SYSDATE LAST_UPDATE_DATE
1846: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1844: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1840: ,OLSTG.PRINT_INVOICE PRINT_INVOICE
1841: ,OLSTG.TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
1842: ,FND_GLOBAL.USER_ID CREATED_BY
1843: ,SYSDATE CREATION_DATE
1844: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1845: ,SYSDATE LAST_UPDATE_DATE
1846: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1847: ,OLSTG.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
1848: ,OLSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER

Line 1846: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1842: ,FND_GLOBAL.USER_ID CREATED_BY
1843: ,SYSDATE CREATION_DATE
1844: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1845: ,SYSDATE LAST_UPDATE_DATE
1846: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1847: ,OLSTG.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
1848: ,OLSTG.TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER
1849: ,OLSTG.EXEMPT_REASON_CODE EXEMPT_REASON_CODE
1850: ,OLSTG.REFERENCE_TEMPLATE_ID COVERAGE_ID

Line 1946: ,FND_GLOBAL.USER_ID CREATED_BY

1942:
1943: SELECT OKSLINB.ID OKSLINB_ID
1944: ,USERENV('LANG') LANGUAGE
1945: ,USERENV('LANG') SOURCE_LANG
1946: ,FND_GLOBAL.USER_ID CREATED_BY
1947: ,SYSDATE CREATION_DATE
1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1944: ,USERENV('LANG') LANGUAGE
1945: ,USERENV('LANG') SOURCE_LANG
1946: ,FND_GLOBAL.USER_ID CREATED_BY
1947: ,SYSDATE CREATION_DATE
1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1951: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1952: FROM OKS_INT_LINE_STG_TEMP OLSTG

Line 1950: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1946: ,FND_GLOBAL.USER_ID CREATED_BY
1947: ,SYSDATE CREATION_DATE
1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1951: ,OLSTG.INVOICE_TEXT INVOICE_TEXT
1952: FROM OKS_INT_LINE_STG_TEMP OLSTG
1953: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1954: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2020: ,FND_GLOBAL.USER_ID CREATED_BY

2016: ,SUB_HDR.FREQUENCY FREQUENCY
2017: ,SUB_HDR.FULFILLMENT_CHANNEL FULFILLMENT_CHANNEL
2018: ,SUB_HDR.OFFSET OFFSET
2019: ,1 OBJECT_VERSION_NUMBER
2020: ,FND_GLOBAL.USER_ID CREATED_BY
2021: ,SYSDATE CREATION_DATE
2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2023: ,SYSDATE LAST_UPDATE_DATE
2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2018: ,SUB_HDR.OFFSET OFFSET
2019: ,1 OBJECT_VERSION_NUMBER
2020: ,FND_GLOBAL.USER_ID CREATED_BY
2021: ,SYSDATE CREATION_DATE
2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2023: ,SYSDATE LAST_UPDATE_DATE
2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2025: FROM OKC_K_LINES_B OKCLINB
2026: ,OKS_INT_LINE_STG_TEMP OLSTG

Line 2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2020: ,FND_GLOBAL.USER_ID CREATED_BY
2021: ,SYSDATE CREATION_DATE
2022: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2023: ,SYSDATE LAST_UPDATE_DATE
2024: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2025: FROM OKC_K_LINES_B OKCLINB
2026: ,OKS_INT_LINE_STG_TEMP OLSTG
2027: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2028: ,OKS_SUBSCR_HEADER_B SUB_HDR

Line 2077: ,FND_GLOBAL.USER_ID CREATED_BY

2073: ,USERENV('LANG') LANGUAGE
2074: ,USERENV('LANG') SOURCE_LANG
2075: ,'N' SFWT_FLAG
2076: ,SUB_HDR_TL.COMMENTS COMMENTS
2077: ,FND_GLOBAL.USER_ID CREATED_BY
2078: ,SYSDATE CREATION_DATE
2079: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2080: ,SYSDATE LAST_UPDATE_DATE
2081: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2079: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2075: ,'N' SFWT_FLAG
2076: ,SUB_HDR_TL.COMMENTS COMMENTS
2077: ,FND_GLOBAL.USER_ID CREATED_BY
2078: ,SYSDATE CREATION_DATE
2079: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2080: ,SYSDATE LAST_UPDATE_DATE
2081: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2082:
2083: FROM OKC_K_LINES_B OKCLINB

Line 2081: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2077: ,FND_GLOBAL.USER_ID CREATED_BY
2078: ,SYSDATE CREATION_DATE
2079: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2080: ,SYSDATE LAST_UPDATE_DATE
2081: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2082:
2083: FROM OKC_K_LINES_B OKCLINB
2084: ,OKS_INT_LINE_STG_TEMP OLSTG
2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2223: ,FND_GLOBAL.USER_ID CREATED_BY

2219: WHEN OCLVLSTG.COVERED_SYSTEM_ID IS NOT NULL THEN 11
2220: END) LSE_ID
2221: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
2222: ,1 OBJECT_VERSION_NUMBER
2223: ,FND_GLOBAL.USER_ID CREATED_BY
2224: ,SYSDATE CREATION_DATE
2225: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2226: ,SYSDATE LAST_UPDATE_DATE
2227: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2225: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2221: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE
2222: ,1 OBJECT_VERSION_NUMBER
2223: ,FND_GLOBAL.USER_ID CREATED_BY
2224: ,SYSDATE CREATION_DATE
2225: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2226: ,SYSDATE LAST_UPDATE_DATE
2227: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2228: ,OCLI.SUBTOTAL SUBTOTAL
2229: ,(CASE WHEN OCLI.SUBTOTAL IS NOT NULL AND OCLI.SUBTOTAL > 0

Line 2227: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2223: ,FND_GLOBAL.USER_ID CREATED_BY
2224: ,SYSDATE CREATION_DATE
2225: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2226: ,SYSDATE LAST_UPDATE_DATE
2227: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2228: ,OCLI.SUBTOTAL SUBTOTAL
2229: ,(CASE WHEN OCLI.SUBTOTAL IS NOT NULL AND OCLI.SUBTOTAL > 0
2230: AND OCLI.QUANTITY_COVERED IS NOT NULL AND OCLI.QUANTITY_COVERED > 0
2231: THEN OCLI.SUBTOTAL/OCLI.QUANTITY_COVERED

Line 2311: ,FND_GLOBAL.USER_ID CREATED_BY

2307: ,OCLI.PRICE_UOM PRICE_UOM
2308: ,OCLI.TAX_AMOUNT TAX_AMOUNT
2309: ,'T' BILLING_SCHEDULE_TYPE
2310: ,1 OBJECT_VERSION_NUMBER
2311: ,FND_GLOBAL.USER_ID CREATED_BY
2312: ,SYSDATE CREATION_DATE
2313: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2314: ,SYSDATE LAST_UPDATE_DATE
2315: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2313: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2309: ,'T' BILLING_SCHEDULE_TYPE
2310: ,1 OBJECT_VERSION_NUMBER
2311: ,FND_GLOBAL.USER_ID CREATED_BY
2312: ,SYSDATE CREATION_DATE
2313: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2314: ,SYSDATE LAST_UPDATE_DATE
2315: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2316:
2317: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

Line 2315: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2311: ,FND_GLOBAL.USER_ID CREATED_BY
2312: ,SYSDATE CREATION_DATE
2313: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2314: ,SYSDATE LAST_UPDATE_DATE
2315: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2316:
2317: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2318: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2319: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2375: ,FND_GLOBAL.USER_ID CREATED_BY

2371: ,USERENV('LANG') LANGUAGE
2372: ,USERENV('LANG') SOURCE_LANG
2373: ,'S' OKS_SFWT_FLAG
2374: ,OCLI.INVOICE_TEXT INVOICE_TEXT
2375: ,FND_GLOBAL.USER_ID CREATED_BY
2376: ,SYSDATE CREATION_DATE
2377: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2378: ,SYSDATE LAST_UPDATE_DATE
2379: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2377: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2373: ,'S' OKS_SFWT_FLAG
2374: ,OCLI.INVOICE_TEXT INVOICE_TEXT
2375: ,FND_GLOBAL.USER_ID CREATED_BY
2376: ,SYSDATE CREATION_DATE
2377: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2378: ,SYSDATE LAST_UPDATE_DATE
2379: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2380:
2381: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

Line 2379: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2375: ,FND_GLOBAL.USER_ID CREATED_BY
2376: ,SYSDATE CREATION_DATE
2377: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2378: ,SYSDATE LAST_UPDATE_DATE
2379: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2380:
2381: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2382: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2383: ,OKC_K_HEADERS_aLL_B OKCHDRB

Line 2497: ,FND_GLOBAL.USER_ID CREATED_BY

2493: ,OCLI.QUANTITY_UOM UOM_CODE
2494: ,'N' EXCEPTION_YN
2495: ,OCLI.QUANTITY_COVERED NUMBER_OF_ITEMS
2496: ,1 OBJECT_VERSION_NUMBER
2497: ,FND_GLOBAL.USER_ID CREATED_BY
2498: ,SYSDATE CREATION_DATE
2499: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2500: ,SYSDATE LAST_UPDATE_DATE
2501: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2499: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2495: ,OCLI.QUANTITY_COVERED NUMBER_OF_ITEMS
2496: ,1 OBJECT_VERSION_NUMBER
2497: ,FND_GLOBAL.USER_ID CREATED_BY
2498: ,SYSDATE CREATION_DATE
2499: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2500: ,SYSDATE LAST_UPDATE_DATE
2501: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2502: ,USERENV('LANG') LANGUAGE
2503: ,USERENV('LANG') SOURCE_LANG

Line 2501: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2497: ,FND_GLOBAL.USER_ID CREATED_BY
2498: ,SYSDATE CREATION_DATE
2499: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2500: ,SYSDATE LAST_UPDATE_DATE
2501: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2502: ,USERENV('LANG') LANGUAGE
2503: ,USERENV('LANG') SOURCE_LANG
2504: ,'N' OKC_SFWT_FLAG
2505: ,OCLI.LINE_REFERENCE LINE_REFERENCE

Line 2604: ,FND_GLOBAL.USER_ID CREATED_BY

2600: ,OUSGCNTSTG.CANCELLATION_REASON CANCELLATION_REASON
2601: ,13 LSE_ID
2602: ,'N' EXCEPTION_YN
2603: ,1 OBJECT_VERSION_NUMBER
2604: ,FND_GLOBAL.USER_ID CREATED_BY
2605: ,SYSDATE CREATION_DATE
2606: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2607: ,SYSDATE LAST_UPDATE_DATE
2608: ,OUSGCNTSTG.SUBTOTAL SUBTOTAL

Line 2606: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2602: ,'N' EXCEPTION_YN
2603: ,1 OBJECT_VERSION_NUMBER
2604: ,FND_GLOBAL.USER_ID CREATED_BY
2605: ,SYSDATE CREATION_DATE
2606: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2607: ,SYSDATE LAST_UPDATE_DATE
2608: ,OUSGCNTSTG.SUBTOTAL SUBTOTAL
2609: ,'Y' PRICED_YN
2610: ,HDRSTG.CONTRACT_CURRENCY_CODE CURRENCY_CODE

Line 2724: ,FND_GLOBAL.USER_ID CREATED_BY

2720: ,NULL USAGE_PERIOD
2721: ,NULL USAGE_TYPE
2722: ,NULL UOM_QUANTIFIED
2723: ,OUSGCNTSTG.PRINT_INVOICE INV_PRINT_FLAG
2724: ,FND_GLOBAL.USER_ID CREATED_BY
2725: ,SYSDATE CREATION_DATE
2726: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2727: ,SYSDATE LAST_UPDATE_DATE
2728: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2726: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2722: ,NULL UOM_QUANTIFIED
2723: ,OUSGCNTSTG.PRINT_INVOICE INV_PRINT_FLAG
2724: ,FND_GLOBAL.USER_ID CREATED_BY
2725: ,SYSDATE CREATION_DATE
2726: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2727: ,SYSDATE LAST_UPDATE_DATE
2728: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2729: ,null ORIG_SYSTEM_SOURCE_CODE
2730: ,null ORIG_SYSTEM_ID1

Line 2728: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2724: ,FND_GLOBAL.USER_ID CREATED_BY
2725: ,SYSDATE CREATION_DATE
2726: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2727: ,SYSDATE LAST_UPDATE_DATE
2728: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2729: ,null ORIG_SYSTEM_SOURCE_CODE
2730: ,null ORIG_SYSTEM_ID1
2731: ,null ORIG_SYSTEM_REFERENCE1
2732: ,'T' BILLING_SCHEDULE_TYPE

Line 2840: ,FND_GLOBAL.USER_ID CREATED_BY

2836: SELECT OKCLINB_SUBLINE.ID OKCLINB_ID
2837: ,USERENV('LANG') LANGUAGE
2838: ,USERENV('LANG') SOURCE_LANG
2839: ,'N' SFWT_FLAG
2840: ,FND_GLOBAL.USER_ID CREATED_BY
2841: ,SYSDATE CREATION_DATE
2842: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2843: ,SYSDATE LAST_UPDATE_DATE
2844: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2842: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2838: ,USERENV('LANG') SOURCE_LANG
2839: ,'N' SFWT_FLAG
2840: ,FND_GLOBAL.USER_ID CREATED_BY
2841: ,SYSDATE CREATION_DATE
2842: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2843: ,SYSDATE LAST_UPDATE_DATE
2844: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2845: ,OUSGCNTSTG.LINE_REFERENCE COGNOMEN
2846: ,OKSLINB.ID OKSLINB_ID

Line 2844: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2840: ,FND_GLOBAL.USER_ID CREATED_BY
2841: ,SYSDATE CREATION_DATE
2842: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2843: ,SYSDATE LAST_UPDATE_DATE
2844: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2845: ,OUSGCNTSTG.LINE_REFERENCE COGNOMEN
2846: ,OKSLINB.ID OKSLINB_ID
2847: ,OUSGCNTINT.INVOICE_TEXT INVOICE_TEXT
2848: ,okc_p_util.raw_to_number(sys_guid()) OKCKITM_ID