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 249: FROM OKS_INT_LINE_STG_TEMP OLSTG

245: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
246: ,SYSDATE LAST_UPDATE_DATE
247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
248:
249: FROM OKS_INT_LINE_STG_TEMP OLSTG
250: ,OKS_INT_HEADER_STG_TEMP HDRSTG
251: ,OKC_K_HEADERS_ALL_B OKCHDRB
252: ,OKC_K_LINES_B OKCLINB_LINE
253: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

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

270: END IF; */
271:
272: l_stmt_num :=20;
273:
274: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
275:
276: --This query creates billing schedules from streams for Subscription lines
277:
278: l_stmt_num :=30 ;

Line 433: FROM OKS_INT_LINE_STG_TEMP OLSTG

429: END) MID_SM_STR_DT
430: , OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
431: ,OLSTG.LINE_TYPE LINE_TYPE
432:
433: FROM OKS_INT_LINE_STG_TEMP OLSTG
434: ,OKC_K_LINES_B OKCLINB_LINE
435: ,OKC_K_HEADERS_ALL_B OKCHDRB
436: ,OKS_INT_HEADER_STG_TEMP HDRSTG
437: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 654: FROM OKS_INT_LINE_STG_TEMP OLSTG

650: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'MTH' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))-- no of months
651: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'QRT' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/3 -- no of quarter
652: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'YR' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/12 -- no of years
653: END) CALC_BILL_PERIOD_2
654: FROM OKS_INT_LINE_STG_TEMP OLSTG
655:
656: ,(SELECT USGSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
657: ,USGSTG.LINE_NUMBER LINE_NUMBER
658: ,USGSTG.START_DATE STR_DT

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

690: END IF; */
691:
692: l_stmt_num :=20;
693:
694: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
695:
696: /* IF G_STMT_LOG THEN
697:
698: fnd_log.string(fnd_log.level_statement,

Line 866: FROM OKS_INT_LINE_STG_TEMP OLSTG

862: ELSE INNER_1.STR_DT
863: END) MID_SM_STR_DT
864: ,OLSTG.LAST_BILL_FROM_DATE -1 MID_SM_END_DT
865:
866: FROM OKS_INT_LINE_STG_TEMP OLSTG
867: ,(SELECT USGSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
868: ,USGSTG.LINE_NUMBER LINE_NUMBER
869: ,USGSTG.START_DATE STR_DT
870: ,USGSTG.END_DATE END_DT

Line 1044: FROM OKS_INT_LINE_STG_TEMP OLSTG

1040: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1041: ,SYSDATE LAST_UPDATE_DATE
1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1043:
1044: FROM OKS_INT_LINE_STG_TEMP OLSTG
1045: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1046: ,OKC_K_HEADERS_ALL_B OKCHDRB
1047: ,OKC_K_LINES_B OKCLINB_LINE
1048: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1220: FROM OKS_INT_LINE_STG_TEMP OLSTG

1216: END) MID_SM_STR_DT
1217: ,OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
1218: ,OLSTG.LINE_TYPE LINE_TYPE
1219:
1220: FROM OKS_INT_LINE_STG_TEMP OLSTG
1221: ,OKC_K_LINES_B OKCLINB_LINE
1222: ,OKC_K_HEADERS_ALL_B OKCHDRB
1223: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1224: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 1440: FROM OKS_INT_LINE_STG_TEMP OLSTG

1436: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'MTH' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))-- no of months
1437: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'QRT' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/3 -- no of quarter
1438: WHEN OLSTG.BILLING_INTERVAL_PERIOD = 'YR' THEN MONTHS_BETWEEN(OLSTG.END_DATE + 1,(OLSTG.FIRST_BILL_UPTO_DATE+1))/12 -- no of years
1439: END) CALC_BILL_PERIOD_2
1440: FROM OKS_INT_LINE_STG_TEMP OLSTG
1441:
1442: ,(SELECT CVLSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
1443: ,CLI.LINE_NUMBER LINE_NUMBER
1444: ,CLI.START_DATE STR_DT

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

1478: END IF; */
1479:
1480: l_stmt_num :=20;
1481:
1482: SELECT MAX(RECUR_BILL_OCCURANCES) INTO l_recur_bill_occurance FROM OKS_INT_LINE_STG_TEMP ;
1483:
1484: /* IF G_STMT_LOG THEN
1485:
1486: fnd_log.string(fnd_log.level_statement,

Line 1654: FROM OKS_INT_LINE_STG_TEMP OLSTG

1650: ELSE INNER_1.STR_DT
1651: END) MID_SM_STR_DT
1652: ,OLSTG.LAST_BILL_FROM_DATE -1 MID_SM_END_DT
1653:
1654: FROM OKS_INT_LINE_STG_TEMP OLSTG
1655: ,(SELECT CVLSTG.LINE_INTERFACE_ID LINE_INTERFACE_ID
1656: ,CLI.LINE_NUMBER LINE_NUMBER
1657: ,CLI.START_DATE STR_DT
1658: ,CLI.END_DATE END_DT

Line 1840: FROM OKS_INT_LINE_STG_TEMP OLSTG

1836: ,SYSDATE CREATION_DATE
1837: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1838: ,SYSDATE LAST_UPDATE_DATE
1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1840: FROM OKS_INT_LINE_STG_TEMP OLSTG
1841: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1842: ,OKC_K_HEADERS_ALL_B OKCHDRB
1843: ,OKC_K_LINES_B OKCLINB_LINE
1844: WHERE OLSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID

Line 1996: FROM OKS_INT_LINE_STG_TEMP OLSTG

1992: ELSE OLSTG.START_DATE
1993: END) MID_SM_STR_DT
1994: ,OLSTG.LAST_BILL_FROM_DATE - 1 MID_SM_END_DT
1995: ,OLSTG.LINE_TYPE LINE_TYPE
1996: FROM OKS_INT_LINE_STG_TEMP OLSTG
1997: ,OKC_K_LINES_B OKCLINB_LINE
1998: ,OKC_K_HEADERS_ALL_B OKCHDRB
1999: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2000: ,OKS_STREAM_LEVELS_B OKS_STRM_LVL

Line 2121: FROM OKS_INT_LINE_STG_TEMP OLSTG

2117: ,OKCLINB_LINE.id as cle_id
2118: ,OKCLINB_LINE.start_date as start_date
2119: ,OKCLINB_LINE.end_date as end_date
2120:
2121: FROM OKS_INT_LINE_STG_TEMP OLSTG
2122: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2123: ,OKC_K_LINES_B OKCLINB_LINE
2124: ,OKS_K_LINES_B OKSLINB_LINE
2125: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 2279: ,OKS_INT_LINE_STG_TEMP OLSTG

2275: ,OKS_NT_INT.ENTERED_BY ENTERED_BY
2276: ,OKS_NT_INT.ENTERED_DATE ENTERED_DATE
2277:
2278: FROM OKS_NOTES_INTERFACE OKS_NT_INT
2279: ,OKS_INT_LINE_STG_TEMP OLSTG
2280: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2281: ,OKC_K_HEADERS_ALL_B OKCHDRB
2282: ,OKC_K_LINES_B OKCLINB
2283:

Line 2521: FROM OKS_INT_LINE_STG_TEMP OLSTG

2517: SELECT OLSTG.ITEM_ID SERVICE_ITEM_ID
2518: ,OKCHDRB.ID HDRB_ID
2519: ,OKCLINB.ID LINB_ID
2520:
2521: FROM OKS_INT_LINE_STG_TEMP OLSTG
2522: ,OKC_K_LINES_B OKCLINB
2523: ,OKC_K_HEADERS_ALL_B OKCHDRB
2524: ,OKS_INT_HEADER_STG_TEMP HDRSTG
2525: