eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_INSERT dependencies on OKC_P_UTIL

Line 331: ,okc_p_util.raw_to_number(sys_guid()) OKCGID

327: ,LAST_UPDATE_DATE
328: ,LAST_UPDATE_LOGIN)
329:
330: SELECT OKCHDRB.ID HDRB_ID
331: ,okc_p_util.raw_to_number(sys_guid()) OKCGID
332: ,okc_p_util.raw_to_number(sys_guid()) OKCKPRID
333: ,USERENV('LANG') LANGUAGE
334: ,USERENV('LANG') SOURCE_LANG
335: ,'N' SFWT_FLAG

Line 332: ,okc_p_util.raw_to_number(sys_guid()) OKCKPRID

328: ,LAST_UPDATE_LOGIN)
329:
330: SELECT OKCHDRB.ID HDRB_ID
331: ,okc_p_util.raw_to_number(sys_guid()) OKCGID
332: ,okc_p_util.raw_to_number(sys_guid()) OKCKPRID
333: ,USERENV('LANG') LANGUAGE
334: ,USERENV('LANG') SOURCE_LANG
335: ,'N' SFWT_FLAG
336: ,HDRSTG.DESCRIPTION SHORT_DESCRIPTION -- no matching column as short_description

Line 502: SELECT okc_p_util.raw_to_number(sys_guid()) OKSHDRB_ID

498: ,EXEMPT_REASON_CODE
499: ,TAX_AMOUNT
500: ,BILLING_SCHEDULE_TYPE)
501:
502: SELECT okc_p_util.raw_to_number(sys_guid()) OKSHDRB_ID
503: ,OKCHDRB.ID CHR_ID
504: ,HDRSTG.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
505: ,HDRSTG.PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION
506: ,HDRSTG.COMMITMENT_ID COMMITMENT_NUMBER_ID

Line 663: SELECT okc_p_util.raw_to_number(sys_guid()) OKCGRP_ID

659: ,LAST_UPDATED_BY
660: ,LAST_UPDATE_DATE
661: ,LAST_UPDATE_LOGIN )
662:
663: SELECT okc_p_util.raw_to_number(sys_guid()) OKCGRP_ID
664: ,1 OBJECT_VERSION_NUMBER
665: ,HDRSTG.CONTRACT_GROUP_ID CONTRACT_GROUP_ID
666: ,OKCHDRB.ID INCLUDED_CHR_ID
667: ,HDRSTG.CATEGORY CATEGORY

Line 749: VALUES (okc_p_util.raw_to_number(sys_guid())

745: ,CREATED_BY
746: ,CREATION_DATE
747: ,LAST_UPDATED_BY
748: ,LAST_UPDATE_DATE)
749: VALUES (okc_p_util.raw_to_number(sys_guid())
750: ,CHR_ID
751: ,CLE_ID
752: ,DNZ_CHR_ID
753: ,RLE_CODE_OPUNIT

Line 778: VALUES (okc_p_util.raw_to_number(sys_guid())

774: ,CREATED_BY
775: ,CREATION_DATE
776: ,LAST_UPDATED_BY
777: ,LAST_UPDATE_DATE)
778: VALUES (okc_p_util.raw_to_number(sys_guid())
779: ,CHR_ID
780: ,CLE_ID
781: ,DNZ_CHR_ID
782: ,RLE_CODE_CUST

Line 806: VALUES (okc_p_util.raw_to_number(sys_guid())

802: ,CREATED_BY
803: ,CREATION_DATE
804: ,LAST_UPDATED_BY
805: ,LAST_UPDATE_DATE)
806: VALUES (okc_p_util.raw_to_number(sys_guid())
807: ,CHR_ID
808: ,CLE_ID
809: ,DNZ_CHR_ID
810: ,'THIRD_PARTY'

Line 819: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID

815: ,CREATED_BY
816: ,CREATION_DATE
817: ,LAST_UPDATED_BY
818: ,LAST_UPDATE_DATE)
819: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID
820: ,OKCHDRB.ID CHR_ID
821: ,null CLE_ID
822: ,OKCHDRB.ID DNZ_CHR_ID
823: ,HDRSTG.OPERATING_UNIT_ID OPERATING_UNIT_ID

Line 887: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID

883: ,CREATION_DATE
884: ,LAST_UPDATED_BY
885: ,LAST_UPDATE_DATE
886: ,LAST_UPDATE_LOGIN)
887: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID
888: ,null CHR_ID
889: ,OKCLINB.ID CLE_ID
890: ,OKCHDRB.ID DNZ_CHR_ID
891: ,HDRSTG.CUSTOMER_PARTY_ID OBJECT1_ID1

Line 1049: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID

1045: ,CREATED_BY
1046: ,CREATION_DATE
1047: ,LAST_UPDATED_BY
1048: ,LAST_UPDATE_DATE)
1049: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
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

Line 1107: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID

1103: ,CREATION_DATE
1104: ,LAST_UPDATED_BY
1105: ,LAST_UPDATE_DATE)
1106:
1107: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1108: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1109: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1110: ,OKCHDRB.ID DNZ_CHR_ID
1111: ,1 OBJECT_VERSION_NUMBER

Line 1151: VALUES (okc_p_util.raw_to_number(sys_guid())

1147: ,CREATION_DATE
1148: ,LAST_UPDATED_BY
1149: ,LAST_UPDATE_DATE
1150: ,LAST_UPDATE_LOGIN )
1151: VALUES (okc_p_util.raw_to_number(sys_guid())
1152: ,CPL_ID
1153: ,'CUST_BILLING'
1154: ,DNZ_CHR_ID
1155: ,CUSTOMER_BILLING_CONTACT_ID

Line 1179: VALUES (okc_p_util.raw_to_number(sys_guid())

1175: ,CREATION_DATE
1176: ,LAST_UPDATED_BY
1177: ,LAST_UPDATE_DATE
1178: ,LAST_UPDATE_LOGIN )
1179: VALUES (okc_p_util.raw_to_number(sys_guid())
1180: ,CPL_ID
1181: ,'CUST_SHIPPING'
1182: ,DNZ_CHR_ID
1183: ,CUSTOMER_SHIPPING_CONTACT_ID

Line 1307: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID

1303: ,LAST_UPDATED_BY
1304: ,LAST_UPDATE_DATE
1305: ,SALESGROUP_ID)
1306:
1307: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID
1308: ,OKSCRSTG.PERCENT PERCENT
1309: ,OKCHDRB.ID CHR_ID
1310: ,null CLE_ID
1311: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID

Line 1363: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID

1359: ,LAST_UPDATED_BY
1360: ,LAST_UPDATE_DATE
1361: ,SALESGROUP_ID
1362: )
1363: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID
1364: ,OKSCRSTG.PERCENT PERCENT
1365: ,OKCHDRB.ID CHR_ID
1366: ,OKCLINB.ID CLE_ID
1367: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID

Line 1516: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID

1512: ,PRICE_NEGOTIATED
1513: ,PRICE_UNIT
1514: ,CUST_ACCT_ID)
1515:
1516: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
1517: ,OLSTG.LINE_NUMBER LINE_NUMBER
1518: ,OKCHDRB.ID CHR_ID
1519: , null CLE_ID
1520: ,OKCHDRB.ID DNZ_CHR_ID

Line 1673: ,okc_p_util.raw_to_number(sys_guid()) OKCKITEM_ID

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
1677: ,OLSTG.ITEM_ID ITEM_ID

Line 1832: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID

1828: ,1
1829: ,pm_program_id
1830: ,pm_sch_exists_yn
1831: ,pm_conf_req_yn)
1832: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
1833: ,OKCLINB.ID CLE_ID
1834: ,OKCHDRB.ID DNZ_CHR_ID
1835: ,OLSTG.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
1836: ,OLSTG.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE

Line 2008: SELECT okc_p_util.raw_to_number(sys_guid()) SUB_HDR_ID

2004: ,LAST_UPDATED_BY
2005: ,LAST_UPDATE_DATE
2006: ,LAST_UPDATE_LOGIN)
2007:
2008: SELECT okc_p_util.raw_to_number(sys_guid()) SUB_HDR_ID
2009: ,OKCLINB.ID CLE_ID
2010: ,OKCHDRB.ID DNZ_CHR_ID
2011: ,SUB_HDR.INSTANCE_ID INSTANCE_ID
2012: ,SUB_HDR.SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE

Line 2206: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID

2202: ,2
2203: ,'N'
2204: ,ANNUALIZED_FACTOR
2205: ,PRICE_LEVEL_IND)
2206: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
2207: ,OKCLINB.ID CLE_ID
2208: ,OCLI.LINE_NUMBER LINE_NUMBER
2209: ,OKCHDRB.ID DNZ_CHR_ID
2210: ,null CHR_ID

Line 2302: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID

2298: ,CREATION_DATE
2299: ,LAST_UPDATED_BY
2300: ,LAST_UPDATE_DATE
2301: ,LAST_UPDATE_LOGIN)
2302: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
2303: ,OKCLINB_subline.ID CLE_ID
2304: ,OKCHDRB.ID DNZ_CHR_ID
2305: ,null CHR_ID
2306: ,OCLI.PRINT_INVOICE PRINT_INVOICE

Line 2468: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKITEMS_ID

2464: ,LAST_UPDATED_BY
2465: ,LAST_UPDATE_DATE
2466: ,LAST_UPDATE_LOGIN
2467: ,LINE_REFERENCE)
2468: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKITEMS_ID
2469: ,OKCLINB_SUBLINE.ID CLE_ID
2470: ,OKCLINB_SUBLINE.ID OKCLINB_ID
2471: ,OKCHDRB.ID DNZ_CHR_ID
2472: ,null CHR_ID

Line 2594: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID

2590: ,ANNUALIZED_FACTOR
2591: ,CANCELLED_AMOUNT
2592: ,RENEWAL_TYPE_CODE)
2593:
2594: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
2595: ,OUSGCNTSTG.LINE_NUMBER LINE_NUMBER
2596: ,null CHR_ID
2597: ,OKCLINB_LINE.ID CLE_ID
2598: ,OKCHDRB.ID DNZ_CHR_ID

Line 2708: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID

2704: ,ORIG_SYSTEM_ID1
2705: ,ORIG_SYSTEM_REFERENCE1
2706: ,ORIG_SYSTEM_SOURCE_CODE
2707: ,1)
2708: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
2709: ,OKCLINB_SUBLINE.ID CLE_ID
2710: ,OKCHDRB.ID DNZ_CHR_ID
2711: ,OUSGCNTSTG.FILL_YN FILL_YN
2712: ,OUSGCNTSTG.ESTIMATION_METHOD ESTIMATION_METHOD

Line 2848: ,okc_p_util.raw_to_number(sys_guid()) OKCKITM_ID

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
2849: ,OKCLINB_SUBLINE.ID CLE_ID
2850: ,null CHR_ID
2851: ,OKCHDRB.ID DNZ_CHR_ID
2852: ,OUSGCNTINT.COUNTER_ID OBJECT1_ID1