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_AR_REVENUE_B_C dependencies on DUAL

Line 1282: SELECT FII_AR_REVENUE_B_S.nextval INTO seq_id FROM dual;

1278: seq_id NUMBER :=0;
1279: l_row_count NUMBER;
1280: BEGIN
1281:
1282: SELECT FII_AR_REVENUE_B_S.nextval INTO seq_id FROM dual;
1283:
1284: if g_debug_flag = 'Y' then
1285: fii_util.put_line(' ');
1286: fii_util.put_line('Merging data into base summary table');

Line 1907: -- into the future will be picked up gradually

1903: -- For 'AR DL', if identifying future dated
1904: -- transactions, do not filter by last updated
1905: -- hours. We will scan only one month into
1906: -- the future. Future dated records too far
1907: -- into the future will be picked up gradually
1908: -- into the future. This is why we can't
1909: -- filter by last_updated hours.
1910: ----------------------------------------------
1911: IF (g_gl_to_date > SYSDATE) THEN

Line 1930: ( select 8 view_type_id from dual

1926: fii_source_ledger_groups fslg
1927: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1928: and fslg.usage_code = :m
1929: ) lidset,
1930: ( select 8 view_type_id from dual
1931: union all
1932: select 7 view_type_id from dual
1933: ) dup
1934: WHERE aeh.accounting_date BETWEEN to_date(:n,''YYYY/MM/DD HH24:MI:SS'') AND to_date(:o,''YYYY/MM/DD HH24:MI:SS'')

Line 1932: select 7 view_type_id from dual

1928: and fslg.usage_code = :m
1929: ) lidset,
1930: ( select 8 view_type_id from dual
1931: union all
1932: select 7 view_type_id from dual
1933: ) dup
1934: WHERE aeh.accounting_date BETWEEN to_date(:n,''YYYY/MM/DD HH24:MI:SS'') AND to_date(:o,''YYYY/MM/DD HH24:MI:SS'')
1935: AND aeh.application_id = 222
1936: AND aeh.balance_type_code = ''A''

Line 1967: ( select 8 view_type_id from dual

1963: fii_source_ledger_groups fslg
1964: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1965: and fslg.usage_code = :a
1966: ) lidset,
1967: ( select 8 view_type_id from dual
1968: union all
1969: select 7 view_type_id from dual
1970: ) dup
1971: WHERE aeh.accounting_date BETWEEN to_date(:b,''YYYY/MM/DD HH24:MI:SS'') AND to_date(:c,''YYYY/MM/DD HH24:MI:SS'')

Line 1969: select 7 view_type_id from dual

1965: and fslg.usage_code = :a
1966: ) lidset,
1967: ( select 8 view_type_id from dual
1968: union all
1969: select 7 view_type_id from dual
1970: ) dup
1971: WHERE aeh.accounting_date BETWEEN to_date(:b,''YYYY/MM/DD HH24:MI:SS'') AND to_date(:c,''YYYY/MM/DD HH24:MI:SS'')
1972: AND aeh.group_id > :m
1973: AND aeh.application_id = 222

Line 2403: FROM (SELECT 'AR INV' data_type, 1 priority FROM DUAL UNION ALL

2399: g_lud_from_date,
2400: g_lud_to_date,
2401: t.data_type,
2402: 'UNASSIGNED'
2403: FROM (SELECT 'AR INV' data_type, 1 priority FROM DUAL UNION ALL
2404: SELECT 'AR ADJ' data_type, 3 priority FROM DUAL) t;
2405:
2406: l_count := l_count + 2;
2407:

Line 2404: SELECT 'AR ADJ' data_type, 3 priority FROM DUAL) t;

2400: g_lud_to_date,
2401: t.data_type,
2402: 'UNASSIGNED'
2403: FROM (SELECT 'AR INV' data_type, 1 priority FROM DUAL UNION ALL
2404: SELECT 'AR ADJ' data_type, 3 priority FROM DUAL) t;
2405:
2406: l_count := l_count + 2;
2407:
2408: COMMIT;

Line 2515: FROM (select 'VERIFY_CCID_UP_TO_DATE' function, 2 phase, 1 priority from dual union all

2511: priority,
2512: g_gl_from_date,
2513: g_gl_to_date,
2514: 'UNASSIGNED'
2515: FROM (select 'VERIFY_CCID_UP_TO_DATE' function, 2 phase, 1 priority from dual union all
2516: select 'REGISTER_EXTRACT_JOBS' function, 3 phase, 1 priority from dual) t;
2517: -- union all select 'DETECT_DELETED_INV' function, 4 phase, 2 priority from dual ) t;
2518:
2519: l_count := l_count + 2;

Line 2516: select 'REGISTER_EXTRACT_JOBS' function, 3 phase, 1 priority from dual) t;

2512: g_gl_from_date,
2513: g_gl_to_date,
2514: 'UNASSIGNED'
2515: FROM (select 'VERIFY_CCID_UP_TO_DATE' function, 2 phase, 1 priority from dual union all
2516: select 'REGISTER_EXTRACT_JOBS' function, 3 phase, 1 priority from dual) t;
2517: -- union all select 'DETECT_DELETED_INV' function, 4 phase, 2 priority from dual ) t;
2518:
2519: l_count := l_count + 2;
2520:

Line 2517: -- union all select 'DETECT_DELETED_INV' function, 4 phase, 2 priority from dual ) t;

2513: g_gl_to_date,
2514: 'UNASSIGNED'
2515: FROM (select 'VERIFY_CCID_UP_TO_DATE' function, 2 phase, 1 priority from dual union all
2516: select 'REGISTER_EXTRACT_JOBS' function, 3 phase, 1 priority from dual) t;
2517: -- union all select 'DETECT_DELETED_INV' function, 4 phase, 2 priority from dual ) t;
2518:
2519: l_count := l_count + 2;
2520:
2521: if g_debug_flag = 'Y' then

Line 3512: SELECT FII_AR_REVENUE_B_S.nextval INTO seq_id FROM dual;

3508: fii_util.start_timer;
3509: fii_util.put_line('');
3510: end if;
3511:
3512: SELECT FII_AR_REVENUE_B_S.nextval INTO seq_id FROM dual;
3513:
3514: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AR_REVENUE_B F (
3515: REVENUE_PK,
3516: GL_DATE_ID,