[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT subsidiary_segment_code, sources_code, context_code
FROM ja_cn_sub_acc_mapping
WHERE chart_of_accounts_id = pn_coa_id
AND sources_code in ('COA', 'PROJECT MODULE')
--choli add to fix bug 12392517
ORDER BY subsidiary_segment_code;
SELECT COUNT(*)
INTO ln_journal_number
FROM (SELECT DISTINCT *--Add by Jianchao Chi, 10-Jan-2011, for one hearder may has two same
FROM ja_cn_journal_lines jl, --line numbers in ja_cn_journal_lines.
gl_ledgers gl,
gl_periods gp,
ja_cn_voucher_number jcvn
--Update by Jianchao Chi, for cnaov2 upgrade
--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 substr(lv_sub_segment_code, 8, 1)
INTO ln_record_number
FROM dual;
SELECT substr(lv_sub_segment_code, 8, 2)
INTO ln_record_number
FROM dual;
SELECT DISTINCT FIFS.SEGMENT_NAME
into lv_record_name
FROM FND_ID_FLEX_SEGMENTS FIFS,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
GL_LEDGERS LED,
FND_FLEX_VALUE_SETS FFVS,
JA_CN_SUB_ACC_MAPPING SAM
WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FIFS.APPLICATION_COLUMN_NAME =
FSAV.APPLICATION_COLUMN_NAME
AND (FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL' OR
(FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_GLOBAL' AND NOT EXISTS
(SELECT *
FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV1
WHERE FSAV1.APPLICATION_ID = FSAV.APPLICATION_ID
AND FSAV1.ID_FLEX_CODE = FSAV.ID_FLEX_CODE
AND FSAV1.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FSAV1.APPLICATION_COLUMN_NAME =
FSAV.APPLICATION_COLUMN_NAME
AND FSAV1.ATTRIBUTE_VALUE = 'Y'
AND FSAV1.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL')))
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FIFS.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = FIFS.ID_FLEX_CODE
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FIFS.APPLICATION_ID = FSAV.APPLICATION_ID
AND LED.CHART_OF_ACCOUNTS_ID = FIFS.ID_FLEX_NUM
AND FFVS.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID
AND LED.CHART_OF_ACCOUNTS_ID = pn_coa_id --parameter: pn_chart_of_account_id
AND SAM.CHART_OF_ACCOUNTS_ID = LED.CHART_OF_ACCOUNTS_ID
AND SAM.CONTEXT_CODE = FSAV.APPLICATION_COLUMN_NAME
AND SAM.SOURCES_CODE = 'COA'
AND FSAV.APPLICATION_COLUMN_NAME = lv_context_code;
SELECT ffvs.description
INTO lv_record_description
FROM fnd_id_flex_segments fifs, fnd_flex_value_sets ffvs
WHERE fifs.id_flex_num = pn_coa_id
AND fifs.id_flex_code = 'GL#'
AND fifs.application_column_name = lv_context_code
AND fifs.flex_value_set_id = ffvs.flex_value_set_id;
SELECT description
INTO lv_record_description
FROM xla_analytical_hdrs_tl
WHERE analytical_criterion_code = 'PROJECT_NUMBER'
AND LANGUAGE = Userenv('LANG');