DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_FINANCIAL_NUMBERS_S

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 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,