DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_LOOKUP_VALUES

Line 9346: -- select * from fnd_lookup_values where lookup_type like 'FUNDS_CHECK_RESULT_CODE'

9342:
9343: --
9344: -- Possible values returned to xla_validation_lines_gt.funds_status_codes
9345: -- can be found using
9346: -- select * from fnd_lookup_values where lookup_type like 'FUNDS_CHECK_RESULT_CODE'
9347: -- and language = 'US' order by lookup_code;
9348: -- In particular, any result code starts with 'F' (FXX) means the line is
9349: -- failed for funds check, and any result code starts with 'P' (PXX) means the line
9350: -- passed funds check.

Line 9385: , fnd_lookup_values flv

9381: , l_array_unrounded_accounted_cr
9382: , l_array_unrounded_accounted_dr
9383: FROM xla_validation_lines_gt xvl
9384: , xla_ae_headers xah
9385: , fnd_lookup_values flv
9386: WHERE xvl.ae_header_id = xah.ae_header_id
9387: AND xvl.accounting_class_code <> 'RFE'
9388: AND flv.lookup_type = 'FUNDS_CHECK_RESULT_CODE'
9389: AND flv.lookup_code = xvl.funds_status_code