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_POST_INSERT dependencies on OKS_INT_LINE_STG_TEMP

Line 269: FROM OKS_INT_LINE_STG_TEMP OLSTG

265: ,SYSDATE LAST_UPDATE_DATE
266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
267: ,bip.tce_code tce_code /*Added for bug:9019205*/
268: ,bip.quantity quantity
269: FROM OKS_INT_LINE_STG_TEMP OLSTG
270: ,OKS_INT_HEADER_STG_TEMP HDRSTG
271: ,OKC_K_HEADERS_ALL_B OKCHDRB
272: ,OKC_K_LINES_B OKCLINB_LINE
273: ,OKC_TIME_CODE_UNITS_B BIP

Line 300: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;

296: END IF; */
297:
298: l_stmt_num :=20;
299:
300: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
301:
302: --This query creates billing schedules from streams for Subscription lines
303:
304: l_stmt_num :=30 ;

Line 532: FROM OKS_INT_LINE_STG_TEMP OLSTG

528: ,OLSTG.LINE_TYPE LINE_TYPE
529: ,bip.tce_code tce_code
530: ,bip.quantity quantity /*Added for bug:9019205*/
531:
532: FROM OKS_INT_LINE_STG_TEMP OLSTG
533: ,OKC_K_LINES_B OKCLINB_LINE
534: ,OKC_K_HEADERS_ALL_B OKCHDRB
535: ,OKS_INT_HEADER_STG_TEMP HDRSTG
536: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 772: FROM OKS_INT_LINE_STG_TEMP OLSTG

768: WHEN bip.tce_code ='MONTH' and bip.quantity =1 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))-- no of months
769: WHEN bip.tce_code ='MONTH' and bip.quantity = 3 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/3 -- no of quarter
770: WHEN bip.tce_code ='YEAR' and bip.quantity =1 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/12 -- no of years
771: END) CALC_BILL_PERIOD_2 /*Added for bug:9019205*/
772: FROM OKS_INT_LINE_STG_TEMP OLSTG
773:
774: ,(SELECT USGSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
775: ,USGSTG.LINE_NUMBER LINE_NUMBER
776: ,USGSTG.START_DATE STR_DT

Line 818: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;

814: END IF; */
815:
816: l_stmt_num :=20;
817:
818: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
819:
820: /* IF G_STMT_LOG THEN
821:
822: fnd_log.string(fnd_log.level_statement,

Line 1038: FROM OKS_INT_LINE_STG_TEMP OLSTG

1034: ,OLSTG.LAST_BILL_FROM_DATE -1 MID_SM_END_DT
1035: ,bip.tce_code tce_code
1036: ,bip.quantity quantity
1037:
1038: FROM OKS_INT_LINE_STG_TEMP OLSTG
1039: ,(SELECT USGSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
1040: ,USGSTG.LINE_NUMBER LINE_NUMBER
1041: ,USGSTG.START_DATE STR_DT
1042: ,USGSTG.END_DATE END_DT

Line 1235: FROM OKS_INT_LINE_STG_TEMP OLSTG

1231: ,SYSDATE LAST_UPDATE_DATE
1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1233: ,bip.tce_code tce_code
1234: ,bip.quantity quantity /*Added for bug:9019205*/
1235: FROM OKS_INT_LINE_STG_TEMP OLSTG
1236: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1237: ,OKC_K_HEADERS_ALL_B OKCHDRB
1238: ,OKC_K_LINES_B OKCLINB_LINE
1239: ,OKC_TIME_CODE_UNITS_B BIP

Line 1465: FROM OKS_INT_LINE_STG_TEMP OLSTG

1461: ,OLSTG.LINE_TYPE LINE_TYPE
1462: ,bip.tce_code tce_code
1463: ,bip.quantity quantity /*Added for bug:9019205*/
1464:
1465: FROM OKS_INT_LINE_STG_TEMP OLSTG
1466: ,OKC_K_LINES_B OKCLINB_LINE
1467: ,OKC_K_HEADERS_ALL_B OKCHDRB
1468: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1469: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 1704: FROM OKS_INT_LINE_STG_TEMP OLSTG

1700: WHEN bip.tce_code ='MONTH' and bip.quantity =1 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))-- no of months
1701: WHEN bip.tce_code ='MONTH' and bip.quantity = 3 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/3 -- no of quarter
1702: WHEN bip.tce_code ='YEAR' and bip.quantity =1 THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/12 -- no of years
1703: END) CALC_BILL_PERIOD_2 /*Added for bug:9019205*/
1704: FROM OKS_INT_LINE_STG_TEMP OLSTG
1705:
1706: ,(SELECT CVLSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
1707: ,CLI.LINE_NUMBER LINE_NUMBER
1708: ,CLI.START_DATE STR_DT

Line 1752: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;

1748: END IF; */
1749:
1750: l_stmt_num :=20;
1751:
1752: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
1753:
1754: /* IF G_STMT_LOG THEN
1755:
1756: fnd_log.string(fnd_log.level_statement,

Line 1972: FROM OKS_INT_LINE_STG_TEMP OLSTG

1968: ,OLSTG.LAST_BILL_FROM_DATE -1 MID_SM_END_DT
1969: ,bip.tce_code tce_code
1970: ,bip.quantity quantity /*Added for bug:9019205*/
1971:
1972: FROM OKS_INT_LINE_STG_TEMP OLSTG
1973: ,(SELECT CVLSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
1974: ,CLI.LINE_NUMBER LINE_NUMBER
1975: ,CLI.START_DATE STR_DT
1976: ,CLI.END_DATE END_DT

Line 2178: FROM OKS_INT_LINE_STG_TEMP OLSTG

2174: ,SYSDATE LAST_UPDATE_DATE
2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2176: ,bip.tce_code tce_code
2177: ,bip.quantity quantity /*Added for bug:9019205*/
2178: FROM OKS_INT_LINE_STG_TEMP OLSTG
2179: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2180: ,OKC_K_HEADERS_ALL_B OKCHDRB
2181: ,OKC_K_LINES_B OKCLINB_LINE
2182: ,OKC_TIME_CODE_UNITS_B BIP

Line 2388: FROM OKS_INT_LINE_STG_TEMP OLSTG

2384: ,OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
2385: ,OLSTG.LINE_TYPE LINE_TYPE
2386: ,bip.tce_code tce_code
2387: ,bip.quantity quantity
2388: FROM OKS_INT_LINE_STG_TEMP OLSTG
2389: ,OKC_K_LINES_B OKCLINB_LINE
2390: ,OKC_K_HEADERS_ALL_B OKCHDRB
2391: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2392: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 2519: FROM OKS_INT_LINE_STG_TEMP OLSTG

2515: ,OKCLINB_LINE.id as cle_id
2516: ,OKCLINB_LINE.start_date as start_date
2517: ,OKCLINB_LINE.end_date as end_date
2518:
2519: FROM OKS_INT_LINE_STG_TEMP OLSTG
2520: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2521: ,OKC_K_LINES_B OKCLINB_LINE
2522: ,OKS_K_LINES_B OKSLINB_LINE
2523: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2677: ,OKS_INT_LINE_STG_TEMP OLSTG

2673: ,OKS_NT_INT.ENTERED_BY ENTERED_BY
2674: ,OKS_NT_INT.ENTERED_DATE ENTERED_DATE
2675:
2676: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2677: ,OKS_INT_LINE_STG_TEMP OLSTG
2678: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2679: ,OKC_K_HEADERS_ALL_B OKCHDRB
2680: ,OKC_K_LINES_B OKCLINB
2681:

Line 2919: FROM OKS_INT_LINE_STG_TEMP OLSTG

2915: SELECT OLSTG.ITEM_ID SERVICE_ITEM_ID
2916: ,OKCHDRB.ID HDRB_ID
2917: ,OKCLINB.ID LINB_ID
2918:
2919: FROM OKS_INT_LINE_STG_TEMP OLSTG
2920: ,OKC_K_LINES_B OKCLINB
2921: ,OKC_K_HEADERS_ALL_B OKCHDRB
2922: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2923: