[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ffvs.maximum_size
,fifs.flex_value_set_id
FROM fnd_id_flex_segments_vl fifs
,fnd_flex_value_sets ffvs
WHERE id_flex_code = 'CAT#'
AND fifs.flex_value_set_id = ffvs.flex_value_set_id
ORDER BY fifs.segment_num;
SELECT concatenated_segment_delimiter
FROM fnd_id_flex_structures
WHERE id_flex_code = 'CAT#';
SELECT DISTINCT fcbk.concatenated_segments category_name
FROM fa_book_controls_sec fbcs
,fa_category_books fcb
,fa_additions_v fav
,fa_categories_b_kfv fcbk
WHERE fbcs.book_type_code = fcb.book_type_code
AND fbcs.set_of_books_id = pn_ledger_id
AND fbcs.book_class IN ('CORPORATE', 'TAX')
AND fav.asset_category_id = fcb.category_id
AND fav.asset_type = 'CAPITALIZED'
-- Choli updated, fix bug 12634759
AND (asset_id in
(SELECT asset_id
FROM FA_BOOKS fb, FA_BOOK_CONTROLS_SEC sec
WHERE fb.BOOK_TYPE_CODE = fcb.book_type_code
AND NVL(DISABLED_FLAG, 'N') = 'N'
AND transaction_header_id_out IS NULL
AND fb.BOOK_TYPE_CODE = sec.BOOK_TYPE_CODE))
----------------------------------------------------------
AND fav.asset_id IN
(SELECT DISTINCT fdh.asset_id
FROM fa_distribution_history fdh
,fa_transaction_headers fth
WHERE fdh.asset_id = fth.asset_id
AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
AND EXISTS
(SELECT fdp.period_close_date
FROM FA_DEPRN_PERIODS fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
ld_end_date
AND fdp.period_close_date IS NOT NULL)
AND fdh.date_effective <
nvl((SELECT MAX(fdp.period_close_date)
FROM FA_DEPRN_PERIODS fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE)
AND (fdh.date_ineffective >
nvl((SELECT MAX(fdp.period_close_date)
FROM FA_DEPRN_PERIODS fdp
WHERE fdp.book_type_code = fbcs.book_type_code
AND fdp.calendar_period_close_date <= ld_end_date
AND fdp.period_close_date IS NOT NULL),
SYSDATE) OR fdh.date_ineffective IS NULL)
AND EXISTS
(SELECT jclllbg.bal_seg_value
FROM ja_cn_ledger_le_bsv_gt jclllbg
WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
jclllbg.bal_seg_value
AND jclllbg.ledger_id = pn_ledger_id
AND jclllbg.legal_entity_id = pn_legal_entity_id))
AND fcbk.category_id = fcb.category_id;
SELECT ffvv.flex_value category_value
,ffvv.description category_name
FROM fnd_id_flex_segments_vl fifs
,fnd_flex_value_sets ffvs
,fnd_flex_values_vl ffvv
WHERE fifs.id_flex_code = 'CAT#'
AND fifs.flex_value_set_id = ffvs.flex_value_set_id
AND ffvv.flex_value_set_id = ffvs.flex_value_set_id
AND ffvv.flex_value = pv_child_category
AND ((ffvv.parent_flex_value_low =
nvl(pv_parent_category, ffvv.parent_flex_value_low) AND
parent_flex_value_low IS NOT NULL) OR
(ffvv.parent_flex_value_low IS NULL))
AND ffvv.flex_value_set_id = pn_value_set_id;
SELECT DISTINCT
jcfc.category_code,
jcfc.category_name
FROM ja_cn_fa_category_gt jcfc
ORDER BY jcfc.category_code;
SELECT start_date
INTO ld_start_date
FROM gl_period_statuses
WHERE ledger_id = pn_ledger_id
AND application_id = 101
AND period_name = pv_period_from
AND to_char(period_year) = pv_accounting_year;
SELECT end_date
INTO ld_end_date
FROM gl_period_statuses
WHERE ledger_id = pn_ledger_id
AND application_id = 101
AND period_name = pv_period_to
AND to_char(period_year) = pv_accounting_year;
INSERT INTO ja_cn_fa_category_gt
(category_code
,category_name
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES
(lv_combined_category_code
,lv_category_name
,fnd_global.user_id
,SYSDATE
,fnd_global.user_id
,SYSDATE
,fnd_global.LOGIN_ID);
INSERT INTO ja_cn_fa_category_gt
(category_code
,category_name
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES
(lv_combined_category_code
,lv_category_name
,fnd_global.user_id
,SYSDATE
,fnd_global.user_id
,SYSDATE
,fnd_global.LOGIN_ID);