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 69: INTO OKC_K_HEADERS_ALL_B

65:
66: l_stmt_num := 10;
67:
68: INSERT
69: INTO OKC_K_HEADERS_ALL_B
70: (ID
71: ,CONTRACT_NUMBER
72: ,AUTHORING_ORG_ID
73: ,CONTRACT_NUMBER_MODIFIER

Line 349: ,OKC_K_HEADERS_ALL_B OKCHDRB

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

Line 551: ,OKC_K_HEADERS_ALL_B OKCHDRB

547: ,NVL(INNER_2.TAX_AMOUNT ,0) TAX_AMOUNT
548: ,'T' BILLING_SCHEDULE_TYPE
549:
550: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
551: ,OKC_K_HEADERS_ALL_B OKCHDRB
552: ,(SELECT INNER_1.HEADER_INTERFACE_ID
553: ,SUM(TAX_AMOUNT) TAX_AMOUNT
554: FROM
555: ((SELECT HDR.HEADER_INTERFACE_ID

Line 675: ,OKC_K_HEADERS_ALL_B OKCHDRB

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

Line 839: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
840:
841: WHERE HDRSTG.INTERFACE_STATUS ='S'
842: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
843: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') ;

Line 907: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
910: ,OKS_INT_LINE_STG_TEMP LINSTG
911:

Line 965: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
967:
968: WHERE HDRSTG.INTERFACE_STATUS ='S'
969: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1060: ,OKC_K_HEADERS_ALL_B OKCHDRB

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

Line 1119: ,OKC_K_HEADERS_ALL_B OKCHDRB

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

Line 1215: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1216: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1217: ,OKC_K_LINES_B OKCLINB
1218:
1219: WHERE HDRSTG.INTERFACE_STATUS='S'

Line 1323: ,OKC_K_HEADERS_ALL_B OKCHDRB

1319: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1320:
1321: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1322: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1323: ,OKC_K_HEADERS_ALL_B OKCHDRB
1324:
1325: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1326: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1327: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1379: ,OKC_K_HEADERS_ALL_B OKCHDRB

1375: ,OKSCRSTG.SALESGROUP_ID SALESGROUP_ID
1376:
1377: FROM OKS_INT_SALES_CREDIT_STG_TEMP OKSCRSTG
1378: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1379: ,OKC_K_HEADERS_ALL_B OKCHDRB
1380: ,OKC_K_LINES_B OKCLINB
1381:
1382: WHERE HDRSTG.HEADER_INTERFACE_ID = OKSCRSTG.HEADER_INTERFACE_ID
1383: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER

Line 1565: ,OKC_K_HEADERS_ALL_B OKCHDRB

1561: / (INNER_Q.NYEARS+1) /(OLSTG.END_DATE-OLSTG.START_DATE+ 1) ANNUALIZED_FACTOR
1562:
1563: FROM OKS_INT_LINE_STG_TEMP OLSTG
1564: ,OKS_INT_HEADER_STG_TEMP OHSTG
1565: ,OKC_K_HEADERS_ALL_B OKCHDRB
1566: ,HZ_CUST_SITE_USES_ALL CSTSITE
1567: ,HZ_CUST_ACCT_SITES_ALL CSTACCT
1568: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, LINE_INTERFACE_ID
1569: FROM OKS_INT_LINE_STG_TEMP LINSTG

Line 1704: ,OKC_K_HEADERS_ALL_B OKCHDRB

1700:
1701: FROM OKC_K_LINES_B OKCLINB
1702: ,OKS_INT_LINE_STG_TEMP OLSTG
1703: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1704: ,OKC_K_HEADERS_ALL_B OKCHDRB
1705:
1706: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
1707: AND HDRSTG.CONTRACT_NUMBER= OKCHDRB.CONTRACT_NUMBER
1708: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER, 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER, 'Xwqwewe@!&*aQ1')

Line 1877: ,OKC_K_HEADERS_ALL_B OKCHDRB

1873: ,COV_IN_QUERY.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
1874: ,COV_IN_QUERY.PM_CONF_REQ_YN PM_CONF_REQ_YN
1875: FROM OKS_INT_LINE_STG_TEMP OLSTG
1876: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1877: ,OKC_K_HEADERS_ALL_B OKCHDRB
1878: ,OKC_K_LINES_B OKCLINB
1879: ,(SELECT SUM(CVLINT.TAX_AMOUNT) AS TAX_AMOUNT
1880: ,CVLSTG.LINE_INTERFACE_ID
1881: FROM OKS_COVERED_LEVELS_INTERFACE CVLINT , OKS_INT_COVERED_LEVEL_STG_TEMP CVLSTG

Line 1954: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
1955: ,OKS_K_LINES_B OKSLINB
1956: ,OKC_K_LINES_B OKCLINB
1957:
1958: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 2029: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
2029: ,OKC_K_HEADERS_ALL_B OKCHDRB
2030: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2031: AND HDRSTG.INTERFACE_STATUS ='S'
2032: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2033: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2089: ,OKC_K_HEADERS_ALL_B OKCHDRB

2085: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2086: ,OKS_SUBSCR_HEADER_B SUB_HDR_1
2087: ,OKS_SUBSCR_HEADER_B SUB_HDR_2
2088: ,OKS_SUBSCR_HEADER_TL SUB_HDR_TL
2089: ,OKC_K_HEADERS_ALL_B OKCHDRB
2090: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID
2091: AND HDRSTG.INTERFACE_STATUS ='S'
2092: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
2093: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 2251: ,OKC_K_HEADERS_ALL_B OKCHDRB

2247: ,'Y' PRICE_LEVEL_IND -- defaulted
2248:
2249: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2250: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2251: ,OKC_K_HEADERS_ALL_B OKCHDRB
2252: ,OKC_K_LINES_B OKCLINB
2253: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2254: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2255: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, COVERED_LEVEL_INTERFACE_ID

Line 2319: ,OKC_K_HEADERS_ALL_B OKCHDRB

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
2320: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2321: ,OKS_INT_LINE_STG_TEMP OKSLINSTG
2322: ,OKC_K_LINES_B OKCLINB_SUBLINE
2323: ,OKC_K_LINES_B OKCLINB_LINE

Line 2383: ,OKC_K_HEADERS_aLL_B OKCHDRB

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
2384: ,OKC_K_LINES_B OKCLINB_LINE
2385: ,OKC_K_LINES_B OKCLINB_SUBLINE
2386: ,OKS_K_LINES_B OKSLINB
2387: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

Line 2509: ,OKC_K_HEADERS_aLL_B OKCHDRB

2505: ,OCLI.LINE_REFERENCE LINE_REFERENCE
2506:
2507: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
2508: ,OKS_INT_COVERED_LEVEL_STG_TEMP OCLVLSTG
2509: ,OKC_K_HEADERS_aLL_B OKCHDRB
2510: ,OKC_K_LINES_B OKCLINB_LINE
2511: ,OKC_K_LINES_B OKCLINB_SUBLINE
2512: ,OKS_K_LINES_B OKSLINB
2513: ,OKS_INT_LINE_STG_TEMP OKSLINSTG

Line 2629: ,OKC_K_HEADERS_ALL_B OKCHDRB

2625: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2626: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2627: ,OKS_INT_LINE_STG_TEMP OLSTG
2628: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2629: ,OKC_K_HEADERS_ALL_B OKCHDRB
2630: ,OKC_K_LINES_B OKCLINB_LINE
2631: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, USAGE_COUNTER_INTERFACE_ID
2632: FROM OKS_INT_USAGE_COUNTER_STG_TEMP USGSTG
2633: ,OKS_INT_LINE_STG_TEMP LINSTG

Line 2737: ,OKC_K_HEADERS_ALL_B OKCHDRB

2733: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2734: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2735: ,OKS_INT_LINE_STG_TEMP OLSTG
2736: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2737: ,OKC_K_HEADERS_ALL_B OKCHDRB
2738: ,OKC_K_LINES_B OKCLINB_SUBLINE
2739: ,OKC_K_LINES_B OKCLINB_LINE
2740: WHERE OUSGCNTINT.USAGE_COUNTER_INTERFACE_ID = OUSGCNTSTG.USAGE_COUNTER_INTERFACE_ID
2741: AND OKCLINB_SUBLINE.DNZ_CHR_ID = OKCHDRB.ID

Line 2864: ,OKC_K_HEADERS_ALL_B OKCHDRB

2860: FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUSGCNTSTG
2861: ,OKS_USAGE_COUNTERS_INTERFACE OUSGCNTINT
2862: ,OKS_INT_LINE_STG_TEMP OLSTG
2863: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2864: ,OKC_K_HEADERS_ALL_B OKCHDRB
2865: ,OKC_K_LINES_B OKCLINB_SUBLINE
2866: ,OKC_K_LINES_B OKCLINB_LINE
2867: ,OKS_K_LINES_B OKSLINB
2868: