[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select xep.legal_entity_id legal_entity_id,
xep.name legal_entity_name,
lg.ledger_id,
rs.primary_ledger_id
from gl_ledger_config_details primdet,
gl_ledgers lg,
gl_ledger_relationships rs,
gl_ledger_configurations cfg,
gl_ledger_config_details cfgdet,
XLE_ENTITY_PROFILES xep
where rs.application_id = 101
and ((rs.target_ledger_category_code = 'SECONDARY' and
rs.relationship_type_code <> 'NONE') or
(rs.target_ledger_category_code = 'PRIMARY' and
rs.relationship_type_code = 'NONE') or
(rs.target_ledger_category_code = 'ALC' and
rs.relationship_type_code in ('JOURNAL', 'SUBLEDGER')))
and lg.ledger_id = rs.target_ledger_id
and lg.ledger_category_code = rs.target_ledger_category_code
and nvl(lg.complete_flag, 'Y') = 'Y'
and primdet.object_id = rs.primary_ledger_id
and primdet.object_type_code = 'PRIMARY'
and primdet.setup_step_code = 'NONE'
and cfg.configuration_id = primdet.configuration_id
and cfgdet.configuration_id(+) = cfg.configuration_id
and cfgdet.object_type_code(+) = 'LEGAL_ENTITY'
and xep.legal_entity_id = cfgdet.object_id
and ledger_id =c_ledger_id;
SELECT gleb.flex_segment_value
FROM GL_LEGAL_ENTITIES_BSVS gleb
WHERE gleb.legal_entity_id = c_legal_id;
SELECT ffv.FLEX_VALUE
FROM FND_FLEX_VALUES_VL ffv
WHERE ffv.FLEX_VALUE_SET_ID=c_flex_value_set_id;
SELECT ledger_id
FROM GL_ACCESS_SET_LEDGERS gas
where gas.access_set_id = p_access_set_id;
SELECT fifsv.FLEX_VALUE_SET_ID
into l_flex_valueset_id
FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = fifsv.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = fifsv.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND fifsv.ID_FLEX_NUM in
(SELECT chart_of_accounts_id
FROM gl_ledgers gls
where gls.ledger_id = l_ledger.ledger_id);
select count(1) into l_bsv_count
from GL_LEGAL_ENTITIES_BSVS gle
where gle.legal_entity_id = l_legal.legal_entity_id;
x_where := x_where ||' and ledger_id in (select ledger_id from gl_access_set_ledgers where access_set_id='||p_access_set_id||')';
SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffv.FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS ffs,
FND_FLEX_VALUES_VL ffv,
GL_LEGAL_ENTITIES_BSVS gleb
WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
AND ffs.flex_value_set_id = gleb.flex_value_set_id
AND ffv.FLEX_VALUE = gleb.flex_segment_value
AND trunc(nvl(START_DATE_ACTIVE, sysdate), 'DD') <=
trunc(sysdate, 'DD')
AND trunc(nvl(END_DATE_ACTIVE, sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND trunc(nvl(start_date,sysdate),'DD')<=
trunc(sysdate, 'DD')
AND trunc(nvl(end_date,sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND gleb.legal_entity_id = p_legal_id;
SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffv.FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv
WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
AND SUMMARY_FLAG = 'N'
AND ENABLED_FLAG = 'Y'
AND trunc(nvl(START_DATE_ACTIVE, sysdate), 'DD') <=
trunc(sysdate, 'DD')
AND trunc(nvl(END_DATE_ACTIVE, sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND ffv.FLEX_VALUE_SET_ID = c_flex_value_set_id;
select cfgdet.object_id legal_entity_id
from gl_ledger_config_details primdet,
gl_ledgers lg,
gl_ledger_relationships rs,
gl_ledger_configurations cfg,
gl_ledger_config_details cfgdet
where rs.application_id = 101
and ((rs.target_ledger_category_code = 'SECONDARY' and
rs.relationship_type_code <> 'NONE') or
(rs.target_ledger_category_code = 'PRIMARY' and
rs.relationship_type_code = 'NONE') or
(rs.target_ledger_category_code = 'ALC' and
rs.relationship_type_code in ('JOURNAL', 'SUBLEDGER')))
and lg.ledger_id = rs.target_ledger_id
and lg.ledger_category_code = rs.target_ledger_category_code
and nvl(lg.complete_flag, 'Y') = 'Y'
and primdet.object_id = rs.primary_ledger_id
and primdet.object_type_code = 'PRIMARY'
and primdet.setup_step_code = 'NONE'
and cfg.configuration_id = primdet.configuration_id
and cfgdet.configuration_id(+) = cfg.configuration_id
and cfgdet.object_type_code(+) = 'LEGAL_ENTITY'
and ledger_id = p_ledger_id;
SELECT fifsv.FLEX_VALUE_SET_ID
into l_flex_valueset_id
FROM FND_ID_FLEX_SEGMENTS_VL fifsv, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = fifsv.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = fifsv.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND fifsv.ID_FLEX_NUM in
(SELECT chart_of_accounts_id
FROM gl_ledgers gls
where gls.ledger_id = p_ledger_id);
select count(1) into l_bsv_count_t
from GL_LEGAL_ENTITIES_BSVS gle
where gle.legal_entity_id = l_le.legal_entity_id
and (sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate) );
select ffh.flex_value_set_id, ffh.FLEX_VALUE, SUMMARY_FLAG
from FND_FLEX_VALUE_CHILDREN_V ffh
where ffh.flex_value_set_id = c_valueset_id
and ffh.PARENT_FLEX_VALUE = c_bsv
order by ffh.FLEX_VALUE;
SELECT fifsv.FLEX_VALUE_SET_ID
into l_flex_valueset_id
FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = fifsv.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = fifsv.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND fifsv.ID_FLEX_NUM in
(SELECT chart_of_accounts_id
FROM gl_ledgers gls
where gls.ledger_id = p_ledger);
SELECT SUMMARY_FLAG
INTO l_summary
FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv
WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
AND ffv.FLEX_VALUE_SET_ID = l_flex_valueset_id
AND ffv.FLEX_VALUE = l_bsv_temp;
SELECT (SELECT COUNT(1)
FROM GL_LEGAL_ENTITIES_BSVS
WHERE LEGAL_ENTITY_ID = p_legal_entity
AND FLEX_VALUE_SET_ID = l_flex_valueset_id
AND trunc(nvl(start_date, sysdate), 'DD') <=
trunc(sysdate, 'DD')
AND trunc(nvl(end_date, sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND FLEX_SEGMENT_VALUE = l_bsv_temp)
INTO l_exists
FROM DUAL;
INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);
SELECT (SELECT COUNT(1)
FROM GL_LEGAL_ENTITIES_BSVS
WHERE LEGAL_ENTITY_ID = p_legal_entity
AND FLEX_VALUE_SET_ID = l_flex_valueset_id
AND trunc(nvl(start_date, sysdate), 'DD') <=
trunc(sysdate, 'DD')
AND trunc(nvl(end_date, sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND FLEX_SEGMENT_VALUE = l_bsv_temp)
INTO l_exists
FROM DUAL;
INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);
select cfgdet.object_id legal_entity_id
from gl_ledger_config_details primdet,
gl_ledgers lg,
gl_ledger_relationships rs,
gl_ledger_configurations cfg,
gl_ledger_config_details cfgdet
where rs.application_id = 101
and ((rs.target_ledger_category_code = 'SECONDARY' and
rs.relationship_type_code <> 'NONE') or
(rs.target_ledger_category_code = 'PRIMARY' and
rs.relationship_type_code = 'NONE') or
(rs.target_ledger_category_code = 'ALC' and
rs.relationship_type_code in ('JOURNAL', 'SUBLEDGER')))
and lg.ledger_id = rs.target_ledger_id
and lg.ledger_category_code = rs.target_ledger_category_code
and nvl(lg.complete_flag, 'Y') = 'Y'
and primdet.object_id = rs.primary_ledger_id
and primdet.object_type_code = 'PRIMARY'
and primdet.setup_step_code = 'NONE'
and cfg.configuration_id = primdet.configuration_id
and cfgdet.configuration_id(+) = cfg.configuration_id
and cfgdet.object_type_code(+) = 'LEGAL_ENTITY'
and ledger_id = p_ledger;
SELECT fifsv.FLEX_VALUE_SET_ID
into l_flex_valueset_id
FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = fifsv.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = fifsv.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND fifsv.ID_FLEX_NUM in
(SELECT chart_of_accounts_id
FROM gl_ledgers gls
where gls.ledger_id = p_ledger);
SELECT (SELECT COUNT(1)
FROM GL_LEGAL_ENTITIES_BSVS
WHERE LEGAL_ENTITY_ID = l_legal.legal_entity_id
AND trunc(nvl(start_date, sysdate), 'DD') <=
trunc(sysdate, 'DD')
AND trunc(nvl(end_date, sysdate), 'DD') >=
trunc(sysdate, 'DD')
AND FLEX_VALUE_SET_ID = l_flex_valueset_id)
INTO l_exists
FROM DUAL;
SELECT (SELECT count(1) FROM JA_CN_BANK_LE_GT )
INTO l_exists
FROM DUAL;
select segment_value
from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas
where gasn.access_set_id = gas.access_set_id
and SECURITY_SEGMENT_CODE = 'B'
and ALL_SEGMENT_VALUE_FLAG='N'
and gasn.access_set_id = p_das
and ledger_id = p_ledger;
select count(1)
into l_das_bsv
from GL_ACCESS_SETS gas
where SECURITY_SEGMENT_CODE = 'B'
and gas.access_set_id = p_das;
SELECT fifsv.FLEX_VALUE_SET_ID
into l_flex_valueset_id
FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.APPLICATION_ID = fifsv.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = fifsv.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = fifsv.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND fifsv.ID_FLEX_NUM in
(SELECT chart_of_accounts_id
FROM gl_ledgers gls
where gls.ledger_id = p_ledger);
select ALL_SEGMENT_VALUE_FLAG
INTO l_bsv_all
from GL_ACCESS_SET_NORM_ASSIGN gasn, GL_ACCESS_SETS gas
where gasn.access_set_id = gas.access_set_id
and SECURITY_SEGMENT_CODE = 'B'
and ALL_SEGMENT_VALUE_FLAG = 'Y'
and gasn.access_set_id = p_das
and ledger_id = p_ledger
and rownum = 1;
select NVL(MEANING, 'Units') INTO v_currency
from RG_REPORT_AXES rga, RG_LOOKUPS LK
where LK.LOOKUP_CODE = rga.display_units
and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
and rownum = 1
AND AXIS_SET_ID =
(select COLUMN_SET_ID from RG_REPORTS WHERE NAME = reportName)
ORDER BY AXIS_SEQ;