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 DUAL

Line 288: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

284: AND BIP.uom_code = BIPTL.uom_code
285: AND BIP.tce_code = BIPTL.tce_code
286: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1
287:
288: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
289: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
290:
291: /* IF G_STMT_LOG THEN
292:

Line 554: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

550: AND BIP.uom_code =BIPTL.uom_code
551: AND BIP.tce_code = BIPTL.tce_code
552: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
553:
554: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
555:
556: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)SUBS_SCH_DT;
557:
558: /*IF G_STMT_LOG THEN

Line 804: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

800: AND BIP.uom_code =BIPTL.uom_code
801: AND BIP.tce_code =BIPTL.tce_code
802: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Modified for bug:9019205*/
803:
804: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
805:
806: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
807:
808: l_int_count := SQL%ROWCOUNT;

Line 1072: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

1068: AND BIP.uom_code =BIPTL.uom_code
1069: AND BIP.tce_code =BIPTL.tce_code
1070: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
1071:
1072: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
1073:
1074: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) COV_SCH_DT;
1075:
1076:

Line 1253: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

1249: AND OLSTG.billing_interval_period=BIP.uom_code(+)
1250: AND BIP.uom_code =BIPTL.uom_code
1251: AND BIP.tce_code =BIPTL.tce_code
1252: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
1253: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
1254: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1255:
1256: /* l_int_count := SQL%ROWCOUNT;
1257: IF G_STMT_LOG THEN

Line 1486: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

1482: AND OLSTG.billing_interval_period=BIP.uom_code(+)
1483: AND BIP.uom_code =BIPTL.uom_code
1484: AND BIP.tce_code =BIPTL.tce_code
1485: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
1486: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
1487: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS)USG_SCH_DT;
1488:
1489:
1490: /*IF G_STMT_LOG THEN

Line 1738: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

1734: AND BIP.uom_code =BIPTL.uom_code
1735: AND BIP.tce_code =BIPTL.tce_code
1736: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
1737:
1738: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
1739:
1740: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
1741:
1742: l_int_count := SQL%ROWCOUNT;

Line 2008: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

2004: AND BIP.uom_code =BIPTL.uom_code
2005: AND BIP.tce_code =BIPTL.tce_code
2006: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
2007:
2008: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
2009:
2010: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) COV_SCH_DT;
2011:
2012: -- Billing Streams and Schedules for Service Lines

Line 2197: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2

2193: AND BIP.uom_code =BIPTL.uom_code
2194: AND BIP.tce_code =BIPTL.tce_code
2195: AND BIPTL.language(+)=USERENV('LANG'))INNER_Q1
2196:
2197: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= 3) INNER_Q2
2198:
2199: WHERE INNER_Q2.SEQ <= INNER_Q1.NUM_STREAMS;
2200:
2201: l_int_count := SQL%ROWCOUNT;

Line 2409: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2

2405: AND OLSTG.billing_interval_period=BIP.uom_code(+)
2406: AND BIP.uom_code =BIPTL.uom_code
2407: AND BIP.tce_code =BIPTL.tce_code
2408: AND BIPTL.language(+)=USERENV('LANG')) INNER_Q1 /*Added for bug:9019205*/
2409: ,(SELECT ROWNUM AS SEQ FROM DUAL CONNECT BY LEVEL <= l_recur_bill_occurance ) INNER_Q2
2410: WHERE INNER_Q2.SEQ <= INNER_Q1.LEVEL_PERIODS) LIN_SCH_DT
2411: WHERE COV_LVL_ELEM.PARENT_CLE_ID = LIN_SCH_DT.CLE_ID
2412: AND COV_LVL_ELEM.DATE_START(+) >= LIN_SCH_DT.DATE_START
2413: AND COV_LVL_ELEM.DATE_END(+) <= LIN_SCH_DT.DATE_END ) SCH_LIN_INSERT;