[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT Settlement_Method_Number, Settlement_Method_Name
FROM (SELECT --for AP
iby1.PAYMENT_METHOD_CODE AS Settlement_Method_Number,
iby1.PAYMENT_METHOD_NAME AS Settlement_Method_Name
FROM iby_payment_methods_vl iby1
UNION
SELECT --for AR
to_char(arm.RECEIPT_METHOD_ID) AS Settlement_Method_Number,
arm.name AS Settlement_Method_Name
FROM AR_RECEIPT_METHODS arm
UNION
SELECT --for GL/AGIS
ffv.FLEX_VALUE AS Settlement_Method_Number,
ffv.DESCRIPTION AS Settlement_Method_Name
FROM FND_FLEX_VALUES_VL ffv, FND_FLEX_VALUE_SETS ffvs
WHERE ffv.FLEX_VALUE_SET_ID = ffvs.flex_value_set_id
AND ffvs.flex_value_set_name = 'JA_CN_SETTLEMENT_METHOD')
--Only existing settlement method in Itemized Journal table should be exported
WHERE Settlement_Method_Number IN
(SELECT jl.Settlement_Method_Number
FROM JA_CN_JOURNAL_LINES jl, ja_cn_voucher_number jcvn
--Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
--Add ja_cn_voucher_number table, voucher number and legal entity
--are fetched from ja_cn_voucher_number
--The new one is
----------------------------------------------------
--AND jcvn.je_header_id = jl.je_header_id
--AND jcvn.je_line_number = jl.je_line_num
--AND jcvn.legal_entity_id = pn_le_id;
(SELECT gps.period_name
FROM GL_PERIOD_STATUSES gps
WHERE gps.ledger_id = jl.ledger_id
AND gps.application_id = 101
and gps.period_year = pv_accounting_year))
ORDER BY Settlement_Method_Number;