DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_LOOKUP_VALUES

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

10023:
10024: --
10025: -- Possible values returned to xla_validation_lines_gt.funds_status_codes
10026: -- can be found using
10027: -- select * from fnd_lookup_values where lookup_type like 'FUNDS_CHECK_RESULT_CODE'
10028: -- and language = 'US' order by lookup_code;
10029: -- In particular, any result code starts with 'F' (FXX) means the line is
10030: -- failed for funds check, and any result code starts with 'P' (PXX) means the line
10031: -- passed funds check.

Line 10066: , fnd_lookup_values flv

10062: , l_array_unrounded_accounted_cr
10063: , l_array_unrounded_accounted_dr
10064: FROM xla_validation_lines_gt xvl
10065: , xla_ae_headers xah
10066: , fnd_lookup_values flv
10067: WHERE xvl.ae_header_id = xah.ae_header_id
10068: AND xvl.accounting_class_code <> 'RFE'
10069: AND flv.lookup_type = 'FUNDS_CHECK_RESULT_CODE'
10070: AND flv.lookup_code = xvl.funds_status_code