VIEW: APPS.AR_SYSTEM_PARAM_H_V

Source

View Text - Preformatted

SELECT sys.CASH_BASIS_SET_OF_BOOKS_ID ,sys.CODE_COMBINATION_ID_GAIN ,NVL(sys.CODE_COMBINATION_ID_LOSS,sys.CODE_COMBINATION_ID_GAIN) ,sys.set_of_books_id ,he.event_id ,FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION') FROM ar_system_parameters_all sys, ar_xla_lines_extract he WHERE sys.org_id = he.org_id AND he.level_flag = 'H'

View Text - HTML Formatted

SELECT SYS.CASH_BASIS_SET_OF_BOOKS_ID
, SYS.CODE_COMBINATION_ID_GAIN
, NVL(SYS.CODE_COMBINATION_ID_LOSS
, SYS.CODE_COMBINATION_ID_GAIN)
, SYS.SET_OF_BOOKS_ID
, HE.EVENT_ID
, FND_PROFILE.VALUE('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION')
FROM AR_SYSTEM_PARAMETERS_ALL SYS
, AR_XLA_LINES_EXTRACT HE
WHERE SYS.ORG_ID = HE.ORG_ID
AND HE.LEVEL_FLAG = 'H'