APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_FINANCIAL_NUMBERS

Line 1568: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,

1564: party_osr,
1565: int_row_id,
1566: -- if ranking is null, there is no match in FR and FN
1567: nvl2(ranking, action_flag, 'I'),
1568: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,
1569: nvl2(ranking, fr_id, null),
1570: type_of_financial_report,
1571: document_reference,
1572: date_report_issued,

Line 1597: from hz_financial_numbers hz_fn,

1593: -- select the highest ranking
1594: rank() over (partition by fi_frid.int_row_id
1595: order by fi_frid.ranking nulls last, fr_rowid) new_rank,
1596: fi_frid.ranking ranking
1597: from hz_financial_numbers hz_fn,
1598: (
1599: -- match all fr ids without the date columns
1600: select /*+ no_merge leading(fi_pid) use_nl(frsg, fr) */
1601: fi_pid.pid, fi_pid.party_os, fi_pid.party_osr,

Line 1703: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,

1699: party_osr,
1700: int_row_id,
1701: -- if ranking is null, there is no match in FR and FN
1702: nvl2(ranking, action_flag, 'I'),
1703: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,
1704: nvl2(ranking, fr_id, null),
1705: type_of_financial_report,
1706: document_reference,
1707: date_report_issued,

Line 1732: from hz_financial_numbers hz_fn,

1728: -- select the highest ranking
1729: rank() over (partition by fi_frid.int_row_id
1730: order by fi_frid.ranking nulls last, fr_rowid) new_rank,
1731: fi_frid.ranking ranking
1732: from hz_financial_numbers hz_fn,
1733: (
1734: -- match all fr ids without the date columns
1735: select /*+ no_merge leading(fi_pid) use_nl(frsg, fr) */
1736: fi_pid.pid, fi_pid.party_os, fi_pid.party_osr,