DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_FINANCIAL_NUMBERS_S

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

1578: party_osr,
1579: int_row_id,
1580: -- if ranking is null, there is no match in FR and FN
1581: nvl2(ranking, action_flag, 'I'),
1582: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,
1583: nvl2(ranking, fr_id, null),
1584: type_of_financial_report,
1585: document_reference,
1586: date_report_issued,

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

1714: party_osr,
1715: int_row_id,
1716: -- if ranking is null, there is no match in FR and FN
1717: nvl2(ranking, action_flag, 'I'),
1718: nvl2(ranking, nvl(hz_fn2.financial_number_id, hz_financial_numbers_s.NextVal), hz_financial_numbers_s.NextVal) fn_id,
1719: nvl2(ranking, fr_id, null),
1720: type_of_financial_report,
1721: document_reference,
1722: date_report_issued,