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_K_HEADERS_ALL_B

Line 64: INTO OKC_K_HEADERS_ALL_B

60:
61: l_stmt_num := 10;
62:
63: INSERT
64: INTO OKC_K_HEADERS_ALL_B
65: (ID
66: ,CONTRACT_NUMBER
67: ,AUTHORING_ORG_ID
68: ,CONTRACT_NUMBER_MODIFIER

Line 344: ,OKC_K_HEADERS_ALL_B OKCHDRB

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'
346: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
347: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;
348:

Line 546: ,OKC_K_HEADERS_ALL_B OKCHDRB

542: ,NVL(INNER_2.TAX_AMOUNT ,0) TAX_AMOUNT
543: ,'T' BILLING_SCHEDULE_TYPE
544:
545: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
546: ,OKC_K_HEADERS_ALL_B OKCHDRB
547: ,(SELECT INNER_1.HEADER_INTERFACE_ID
548: ,SUM(TAX_AMOUNT) TAX_AMOUNT
549: FROM
550: ((SELECT HDR.HEADER_INTERFACE_ID

Line 670: ,OKC_K_HEADERS_ALL_B OKCHDRB

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'
672: AND HDRSTG.CONTRACT_NUMBER=OKCHDRB.CONTRACT_NUMBER
673: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;
674:

Line 834: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
835:
836: WHERE HDRSTG.INTERFACE_STATUS ='S'
837: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
838: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 902: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
905: ,OKS_INT_LINE_STG_TEMP LINSTG
906:

Line 960: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
962:
963: WHERE HDRSTG.INTERFACE_STATUS ='S'
964: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1055: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1056: WHERE HDRSTG.INTERFACE_STATUS='S'
1057: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1058: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')
1059: AND OKCKPTYRL.DNZ_CHR_ID = OKCHDRB.ID

Line 1114: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1115: WHERE HDRSTG.INTERFACE_STATUS='S'
1116: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1117: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')
1118: AND OKCKPTYRL.DNZ_CHR_ID = OKCHDRB.ID

Line 1210: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1211: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1212: ,OKC_K_LINES_B OKCLINB
1213:
1214: WHERE HDRSTG.INTERFACE_STATUS='S'

Line 1318: ,OKC_K_HEADERS_ALL_B OKCHDRB

1314: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1315:
1316: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1317: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1318: ,OKC_K_HEADERS_ALL_B OKCHDRB
1319:
1320: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1321: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1322: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1374: ,OKC_K_HEADERS_ALL_B OKCHDRB

1370: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1371:
1372: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1373: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1374: ,OKC_K_HEADERS_ALL_B OKCHDRB
1375: ,OKC_K_LINES_B OKCLINB
1376:
1377: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1378: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1560: ,OKC_K_HEADERS_ALL_B OKCHDRB

1556: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
1557:
1558: FROM OKS_INT_LINE_STG_TEMP OLSTG
1559: ,OKS_INT_HEADER_STG_TEMP OHSTG
1560: ,OKC_K_HEADERS_ALL_B OKCHDRB
1561: ,HZ_CUST_SITE_USES_ALL CSTSITE
1562: ,HZ_CUST_ACCT_SITES_ALL CSTACCT
1563: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, LINE_INTERFACE_ID
1564: FROM OKS_INT_LINE_STG_TEMP LINSTG

Line 1696: ,OKC_K_HEADERS_ALL_B OKCHDRB

1692:
1693: FROM OKC_K_LINES_B OKCLINB
1694: ,OKS_INT_LINE_STG_TEMP OLSTG
1695: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1696: ,OKC_K_HEADERS_ALL_B OKCHDRB
1697:
1698: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1699: AND HDRSTG.CONTRACT_NUMBER= OKCHDRB.CONTRACT_NUMBER
1700: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER, 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER, 'Xwqwewe@!&*aQ1')

Line 1869: ,OKC_K_HEADERS_ALL_B OKCHDRB

1865: ,COV_IN_QUERY.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
1866: ,COV_IN_QUERY.PM_CONF_REQ_YN PM_CONF_REQ_YN
1867: FROM OKS_INT_LINE_STG_TEMP OLSTG
1868: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1869: ,OKC_K_HEADERS_ALL_B OKCHDRB
1870: ,OKC_K_LINES_B OKCLINB
1871: ,(SELECT SUM(CVLINT.TAX_AMOUNT) AS TAX_AMOUNT
1872: ,CVLSTG.LINE_INTERFACE_ID
1873: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG

Line 1946: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1947: ,OKS_K_LINES_B OKSLINB
1948: ,OKC_K_LINES_B OKCLINB
1949:
1950: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2021: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
2021: ,OKC_K_HEADERS_ALL_B OKCHDRB
2022: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2023: AND HDRSTG.INTERFACE_STATUS ='S'
2024: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2025: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2081: ,OKC_K_HEADERS_ALL_B OKCHDRB

2077: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2078: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2079: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2080: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2081: ,OKC_K_HEADERS_ALL_B OKCHDRB
2082: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2083: AND HDRSTG.INTERFACE_STATUS ='S'
2084: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2085: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2241: ,OKC_K_HEADERS_ALL_B OKCHDRB

2237: ,'Y' PRICE_LEVEL_IND -- defaulted
2238:
2239: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2240: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2241: ,OKC_K_HEADERS_ALL_B OKCHDRB
2242: ,OKC_K_LINES_B OKCLINB
2243: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2244: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2245: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID

Line 2309: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
2310: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2311: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2312: ,OKC_K_LINES_B OKCLINB_SUBLINE
2313: ,OKC_K_LINES_B OKCLINB_LINE

Line 2373: ,OKC_K_HEADERS_aLL_B OKCHDRB

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
2374: ,OKC_K_LINES_B OKCLINB_LINE
2375: ,OKC_K_LINES_B OKCLINB_SUBLINE
2376: ,OKS_K_LINES_B OKSLINB
2377: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

Line 2499: ,OKC_K_HEADERS_aLL_B OKCHDRB

2495: ,OCLI.LINE_REFERENCE LINE_REFERENCE
2496:
2497: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2498: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2499: ,OKC_K_HEADERS_aLL_B OKCHDRB
2500: ,OKC_K_LINES_B OKCLINB_LINE
2501: ,OKC_K_LINES_B OKCLINB_SUBLINE
2502: ,OKS_K_LINES_B OKSLINB
2503: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

Line 2619: ,OKC_K_HEADERS_ALL_B OKCHDRB

2615: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2616: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2617: ,OKS_INT_LINE_STG_TEMP OLSTG
2618: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2619: ,OKC_K_HEADERS_ALL_B OKCHDRB
2620: ,OKC_K_LINES_B OKCLINB_LINE
2621: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2622: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2623: ,OKS_INT_LINE_STG_TEMP LINSTG

Line 2727: ,OKC_K_HEADERS_ALL_B OKCHDRB

2723: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2724: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2725: ,OKS_INT_LINE_STG_TEMP OLSTG
2726: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2727: ,OKC_K_HEADERS_ALL_B OKCHDRB
2728: ,OKC_K_LINES_B OKCLINB_SUBLINE
2729: ,OKC_K_LINES_B OKCLINB_LINE
2730: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2731: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID

Line 2854: ,OKC_K_HEADERS_ALL_B OKCHDRB

2850: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2851: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2852: ,OKS_INT_LINE_STG_TEMP OLSTG
2853: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2854: ,OKC_K_HEADERS_ALL_B OKCHDRB
2855: ,OKC_K_LINES_B OKCLINB_SUBLINE
2856: ,OKC_K_LINES_B OKCLINB_LINE
2857: ,OKS_K_LINES_B OKSLINB
2858: