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 326: ,okc_p_util.raw_to_number(sys_guid()) OKCGID

322: ,LAST_UPDATE_DATE
323: ,LAST_UPDATE_LOGIN)
324:
325: SELECT OKCHDRB.ID HDRB_ID
326: ,okc_p_util.raw_to_number(sys_guid()) OKCGID
327: ,okc_p_util.raw_to_number(sys_guid()) OKCKPRID
328: ,USERENV('LANG') LANGUAGE
329: ,USERENV('LANG') SOURCE_LANG
330: ,'N' SFWT_FLAG

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

323: ,LAST_UPDATE_LOGIN)
324:
325: SELECT OKCHDRB.ID HDRB_ID
326: ,okc_p_util.raw_to_number(sys_guid()) OKCGID
327: ,okc_p_util.raw_to_number(sys_guid()) OKCKPRID
328: ,USERENV('LANG') LANGUAGE
329: ,USERENV('LANG') SOURCE_LANG
330: ,'N' SFWT_FLAG
331: ,HDRSTG.DESCRIPTION SHORT_DESCRIPTION -- no matching column as short_description

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

493: ,EXEMPT_REASON_CODE
494: ,TAX_AMOUNT
495: ,BILLING_SCHEDULE_TYPE)
496:
497: SELECT okc_p_util.raw_to_number(sys_guid()) OKSHDRB_ID
498: ,OKCHDRB.ID CHR_ID
499: ,HDRSTG.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
500: ,HDRSTG.PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION
501: ,HDRSTG.COMMITMENT_ID COMMITMENT_NUMBER_ID

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

654: ,LAST_UPDATED_BY
655: ,LAST_UPDATE_DATE
656: ,LAST_UPDATE_LOGIN )
657:
658: SELECT okc_p_util.raw_to_number(sys_guid()) OKCGRP_ID
659: ,1 OBJECT_VERSION_NUMBER
660: ,HDRSTG.CONTRACT_GROUP_ID CONTRACT_GROUP_ID
661: ,OKCHDRB.ID INCLUDED_CHR_ID
662: ,HDRSTG.CATEGORY CATEGORY

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

740: ,CREATED_BY
741: ,CREATION_DATE
742: ,LAST_UPDATED_BY
743: ,LAST_UPDATE_DATE)
744: VALUES (okc_p_util.raw_to_number(sys_guid())
745: ,CHR_ID
746: ,CLE_ID
747: ,DNZ_CHR_ID
748: ,RLE_CODE_OPUNIT

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

769: ,CREATED_BY
770: ,CREATION_DATE
771: ,LAST_UPDATED_BY
772: ,LAST_UPDATE_DATE)
773: VALUES (okc_p_util.raw_to_number(sys_guid())
774: ,CHR_ID
775: ,CLE_ID
776: ,DNZ_CHR_ID
777: ,RLE_CODE_CUST

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

797: ,CREATED_BY
798: ,CREATION_DATE
799: ,LAST_UPDATED_BY
800: ,LAST_UPDATE_DATE)
801: VALUES (okc_p_util.raw_to_number(sys_guid())
802: ,CHR_ID
803: ,CLE_ID
804: ,DNZ_CHR_ID
805: ,'THIRD_PARTY'

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

810: ,CREATED_BY
811: ,CREATION_DATE
812: ,LAST_UPDATED_BY
813: ,LAST_UPDATE_DATE)
814: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID
815: ,OKCHDRB.ID CHR_ID
816: ,null CLE_ID
817: ,OKCHDRB.ID DNZ_CHR_ID
818: ,HDRSTG.OPERATING_UNIT_ID OPERATING_UNIT_ID

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

878: ,CREATION_DATE
879: ,LAST_UPDATED_BY
880: ,LAST_UPDATE_DATE
881: ,LAST_UPDATE_LOGIN)
882: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKPTYRL_ID
883: ,null CHR_ID
884: ,OKCLINB.ID CLE_ID
885: ,OKCHDRB.ID DNZ_CHR_ID
886: ,HDRSTG.CUSTOMER_PARTY_ID OBJECT1_ID1

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

1040: ,CREATED_BY
1041: ,CREATION_DATE
1042: ,LAST_UPDATED_BY
1043: ,LAST_UPDATE_DATE)
1044: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
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

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

1098: ,CREATION_DATE
1099: ,LAST_UPDATED_BY
1100: ,LAST_UPDATE_DATE)
1101:
1102: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1103: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1104: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1105: ,OKCHDRB.ID DNZ_CHR_ID
1106: ,1 OBJECT_VERSION_NUMBER

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

1142: ,CREATION_DATE
1143: ,LAST_UPDATED_BY
1144: ,LAST_UPDATE_DATE
1145: ,LAST_UPDATE_LOGIN )
1146: VALUES (okc_p_util.raw_to_number(sys_guid())
1147: ,CPL_ID
1148: ,'CUST_BILLING'
1149: ,DNZ_CHR_ID
1150: ,CUSTOMER_BILLING_CONTACT_ID

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

1170: ,CREATION_DATE
1171: ,LAST_UPDATED_BY
1172: ,LAST_UPDATE_DATE
1173: ,LAST_UPDATE_LOGIN )
1174: VALUES (okc_p_util.raw_to_number(sys_guid())
1175: ,CPL_ID
1176: ,'CUST_SHIPPING'
1177: ,DNZ_CHR_ID
1178: ,CUSTOMER_SHIPPING_CONTACT_ID

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

1298: ,LAST_UPDATED_BY
1299: ,LAST_UPDATE_DATE
1300: ,SALESGROUP_ID)
1301:
1302: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID
1303: ,OKSCRSTG.PERCENT PERCENT
1304: ,OKCHDRB.ID CHR_ID
1305: ,null CLE_ID
1306: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID

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

1354: ,LAST_UPDATED_BY
1355: ,LAST_UPDATE_DATE
1356: ,SALESGROUP_ID
1357: )
1358: SELECT okc_p_util.raw_to_number(sys_guid()) OKCSALESCR_ID
1359: ,OKSCRSTG.PERCENT PERCENT
1360: ,OKCHDRB.ID CHR_ID
1361: ,OKCLINB.ID CLE_ID
1362: ,OKSCRSTG.SALESPERSON_ID SALESPERSON_ID

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

1507: ,PRICE_NEGOTIATED
1508: ,PRICE_UNIT
1509: ,CUST_ACCT_ID)
1510:
1511: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
1512: ,OLSTG.LINE_NUMBER LINE_NUMBER
1513: ,OKCHDRB.ID CHR_ID
1514: , null CLE_ID
1515: ,OKCHDRB.ID DNZ_CHR_ID

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

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

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

1820: ,1
1821: ,pm_program_id
1822: ,pm_sch_exists_yn
1823: ,pm_conf_req_yn)
1824: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
1825: ,OKCLINB.ID CLE_ID
1826: ,OKCHDRB.ID DNZ_CHR_ID
1827: ,OLSTG.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
1828: ,OLSTG.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE

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

1996: ,LAST_UPDATED_BY
1997: ,LAST_UPDATE_DATE
1998: ,LAST_UPDATE_LOGIN)
1999:
2000: SELECT okc_p_util.raw_to_number(sys_guid()) SUB_HDR_ID
2001: ,OKCLINB.ID CLE_ID
2002: ,OKCHDRB.ID DNZ_CHR_ID
2003: ,SUB_HDR.INSTANCE_ID INSTANCE_ID
2004: ,SUB_HDR.SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE

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

2194: ,2
2195: ,'N'
2196: ,ANNUALIZED_FACTOR
2197: ,PRICE_LEVEL_IND)
2198: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
2199: ,OKCLINB.ID CLE_ID
2200: ,OCLI.LINE_NUMBER LINE_NUMBER
2201: ,OKCHDRB.ID DNZ_CHR_ID
2202: ,null CHR_ID

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

2288: ,CREATION_DATE
2289: ,LAST_UPDATED_BY
2290: ,LAST_UPDATE_DATE
2291: ,LAST_UPDATE_LOGIN)
2292: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
2293: ,OKCLINB_subline.ID CLE_ID
2294: ,OKCHDRB.ID DNZ_CHR_ID
2295: ,null CHR_ID
2296: ,OCLI.PRINT_INVOICE PRINT_INVOICE

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

2454: ,LAST_UPDATED_BY
2455: ,LAST_UPDATE_DATE
2456: ,LAST_UPDATE_LOGIN
2457: ,LINE_REFERENCE)
2458: SELECT okc_p_util.raw_to_number(sys_guid()) OKCKITEMS_ID
2459: ,OKCLINB_SUBLINE.ID CLE_ID
2460: ,OKCLINB_SUBLINE.ID OKCLINB_ID
2461: ,OKCHDRB.ID DNZ_CHR_ID
2462: ,null CHR_ID

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

2580: ,ANNUALIZED_FACTOR
2581: ,CANCELLED_AMOUNT
2582: ,RENEWAL_TYPE_CODE)
2583:
2584: SELECT okc_p_util.raw_to_number(sys_guid()) OKCLINB_ID
2585: ,OUSGCNTSTG.LINE_NUMBER LINE_NUMBER
2586: ,null CHR_ID
2587: ,OKCLINB_LINE.ID CLE_ID
2588: ,OKCHDRB.ID DNZ_CHR_ID

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

2694: ,ORIG_SYSTEM_ID1
2695: ,ORIG_SYSTEM_REFERENCE1
2696: ,ORIG_SYSTEM_SOURCE_CODE
2697: ,1)
2698: SELECT okc_p_util.raw_to_number(sys_guid()) OKSLINB_ID
2699: ,OKCLINB_SUBLINE.ID CLE_ID
2700: ,OKCHDRB.ID DNZ_CHR_ID
2701: ,OUSGCNTSTG.FILL_YN FILL_YN
2702: ,OUSGCNTSTG.ESTIMATION_METHOD ESTIMATION_METHOD

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

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
2839: ,OKCLINB_SUBLINE.ID CLE_ID
2840: ,null CHR_ID
2841: ,OKCHDRB.ID DNZ_CHR_ID
2842: ,OUSGCNTINT.COUNTER_ID OBJECT1_ID1