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.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_FINANCIAL_REPORTS

Line 1354: 'U', 'I'), nvl(FINANCIAL_REPORT_ID, hz_financial_reports_s.NextVal),

1350: BATCH_ID,
1351: BATCH_MODE_FLAG
1352: )
1353: select pid, party_os, party_osr, int_row_id, nvl2(FINANCIAL_REPORT_ID,
1354: 'U', 'I'), nvl(FINANCIAL_REPORT_ID, hz_financial_reports_s.NextVal),
1355: DOCUMENT_REFERENCE, TYPE_OF_FINANCIAL_REPORT, DATE_REPORT_ISSUED,
1356: REPORT_START_DATE, REPORT_END_DATE, ISSUED_PERIOD, P_BATCH_ID,
1357: P_BATCH_MODE_FLAG
1358: from (

Line 1385: from HZ_FINANCIAL_REPORTS hz_fr1,

1381: when trunc(fr_int_w_pid.REPORT_START_DATE) =
1382: trunc(hz_fr1.REPORT_START_DATE)
1383: and trunc(fr_int_w_pid.REPORT_END_DATE) =
1384: trunc(hz_fr1.REPORT_END_DATE) then 2 end ranking
1385: from HZ_FINANCIAL_REPORTS hz_fr1,
1386: (select /*+ no_merge leading(fr_int) index_asc(fr_int)
1387: use_hash(party_sg) use_nl(mosr) */
1388: nvl(nvl(nvl(fr_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
1389: fr_int.party_orig_system party_os,

Line 1449: 'U', 'I'), nvl(FINANCIAL_REPORT_ID, hz_financial_reports_s.NextVal),

1445: BATCH_ID,
1446: BATCH_MODE_FLAG
1447: )
1448: select pid, party_os, party_osr, int_row_id, nvl2(FINANCIAL_REPORT_ID,
1449: 'U', 'I'), nvl(FINANCIAL_REPORT_ID, hz_financial_reports_s.NextVal),
1450: DOCUMENT_REFERENCE, TYPE_OF_FINANCIAL_REPORT, DATE_REPORT_ISSUED,
1451: REPORT_START_DATE, REPORT_END_DATE, ISSUED_PERIOD, P_BATCH_ID,
1452: P_BATCH_MODE_FLAG
1453: from (

Line 1480: from HZ_FINANCIAL_REPORTS hz_fr1,

1476: when trunc(fr_int_w_pid.REPORT_START_DATE) =
1477: trunc(hz_fr1.REPORT_START_DATE)
1478: and trunc(fr_int_w_pid.REPORT_END_DATE) =
1479: trunc(hz_fr1.REPORT_END_DATE) then 2 end ranking
1480: from HZ_FINANCIAL_REPORTS hz_fr1,
1481: (select /*+ no_merge leading(fr_int) index_asc(fr_int)
1482: use_hash(party_sg) use_nl(mosr) */
1483: nvl(nvl(nvl(fr_int.party_id,party_sg.party_id),osr_ch_tbl.entity_id),mosr.owner_table_id) pid,
1484: fr_int.party_orig_system party_os,

Line 1655: hz_financial_reports fr

1651: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1652: and mosr.status (+) = 'A'
1653: ) fi_pid,
1654: hz_imp_finreports_sg frsg,
1655: hz_financial_reports fr
1656: where fi_pid.pid = frsg.party_id (+)
1657: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1658: and fi_pid.document_reference = frsg.document_reference (+)
1659: and frsg.batch_mode_flag(+) = P_BATCH_MODE_FLAG

Line 1790: hz_financial_reports fr

1786: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1787: and mosr.status (+) = 'A'
1788: ) fi_pid,
1789: hz_imp_finreports_sg frsg,
1790: hz_financial_reports fr
1791: where fi_pid.pid = frsg.party_id (+)
1792: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1793: and fi_pid.document_reference = frsg.document_reference (+)
1794: and frsg.batch_mode_flag(+) = P_BATCH_MODE_FLAG