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