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.FII_AP_INV_SUM_INIT dependencies on DUAL

Line 1233: execute immediate('SELECT 1 FROM (SELECT '' '' SOURCE FROM DUAL)

1229: format of the profile option is valid. Correct format is: 'Source1',..,'SourceN'*/
1230: g_manual_sources := upper(g_manual_sources);
1231: IF g_manual_sources IS NULL THEN g_manual_sources := ''''''; END IF;
1232: BEGIN
1233: execute immediate('SELECT 1 FROM (SELECT '' '' SOURCE FROM DUAL)
1234: WHERE SOURCE IN (' || g_manual_sources || ')');
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: RAISE g_invalid_manual_source;

Line 5678: FROM dual;

5674: end if;
5675:
5676: SELECT fii_ap_pay_sched_b_s.nextval
5677: INTO g_seq_id
5678: FROM dual;
5679:
5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';
5681: if g_debug_flag = 'Y' then
5682: FII_UTIL.put_line(g_state);

Line 6418: (SELECT 1 marker FROM DUAL UNION ALL

6414: AND PS.Invoice_ID = TEMP.Invoice_ID (+)
6415: AND PS.Payment_Num = TEMP.Payment_Num (+)
6416: AND PS.Invoice_ID = PP.Invoice_ID (+)
6417: AND PS.Payment_Num = PP.Payment_Num (+)) Bucket_Calcs,
6418: (SELECT 1 marker FROM DUAL UNION ALL
6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL

Line 6419: SELECT 2 marker FROM DUAL UNION ALL

6415: AND PS.Payment_Num = TEMP.Payment_Num (+)
6416: AND PS.Invoice_ID = PP.Invoice_ID (+)
6417: AND PS.Payment_Num = PP.Payment_Num (+)) Bucket_Calcs,
6418: (SELECT 1 marker FROM DUAL UNION ALL
6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL

Line 6420: SELECT 3 marker FROM DUAL UNION ALL

6416: AND PS.Invoice_ID = PP.Invoice_ID (+)
6417: AND PS.Payment_Num = PP.Payment_Num (+)) Bucket_Calcs,
6418: (SELECT 1 marker FROM DUAL UNION ALL
6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL

Line 6421: SELECT 4 marker FROM DUAL UNION ALL

6417: AND PS.Payment_Num = PP.Payment_Num (+)) Bucket_Calcs,
6418: (SELECT 1 marker FROM DUAL UNION ALL
6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL

Line 6422: SELECT 5 marker FROM DUAL UNION ALL

6418: (SELECT 1 marker FROM DUAL UNION ALL
6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL

Line 6423: SELECT 6 marker FROM DUAL UNION ALL

6419: SELECT 2 marker FROM DUAL UNION ALL
6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL

Line 6424: SELECT 7 marker FROM DUAL UNION ALL

6420: SELECT 3 marker FROM DUAL UNION ALL
6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL

Line 6425: SELECT 8 marker FROM DUAL UNION ALL

6421: SELECT 4 marker FROM DUAL UNION ALL
6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL
6429: SELECT 12 marker FROM DUAL) TMP)

Line 6426: SELECT 9 marker FROM DUAL UNION ALL

6422: SELECT 5 marker FROM DUAL UNION ALL
6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL
6429: SELECT 12 marker FROM DUAL) TMP)
6430: WHERE SDate IS NOT NULL

Line 6427: SELECT 10 marker FROM DUAL UNION ALL

6423: SELECT 6 marker FROM DUAL UNION ALL
6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL
6429: SELECT 12 marker FROM DUAL) TMP)
6430: WHERE SDate IS NOT NULL
6431: GROUP BY Org_ID, Supplier_ID, Invoice_ID, SDate)

Line 6428: SELECT 11 marker FROM DUAL UNION ALL

6424: SELECT 7 marker FROM DUAL UNION ALL
6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL
6429: SELECT 12 marker FROM DUAL) TMP)
6430: WHERE SDate IS NOT NULL
6431: GROUP BY Org_ID, Supplier_ID, Invoice_ID, SDate)
6432:

Line 6429: SELECT 12 marker FROM DUAL) TMP)

6425: SELECT 8 marker FROM DUAL UNION ALL
6426: SELECT 9 marker FROM DUAL UNION ALL
6427: SELECT 10 marker FROM DUAL UNION ALL
6428: SELECT 11 marker FROM DUAL UNION ALL
6429: SELECT 12 marker FROM DUAL) TMP)
6430: WHERE SDate IS NOT NULL
6431: GROUP BY Org_ID, Supplier_ID, Invoice_ID, SDate)
6432:
6433: COMMIT;