[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT multi_org_flag
FROM fnd_product_groups;
SELECT pn.org_id,
gl.name,
gl.chart_of_accounts_id,
hr.name,
gl.currency_code,
pn.set_of_books_id,
pn.accounting_option,
pn.default_currency_conv_type,
pn.space_assign_sysdate_optn,
pn.multiple_tenancy_lease,
pn.auto_space_distribution,
pn.auto_comp_num_gen,
pn.auto_lease_num_gen,
pn.auto_index_num_gen,
pn.auto_var_rent_num_gen,
pn.auto_rec_agr_num_flag,
pn.auto_rec_exp_num_flag,
pn.auto_rec_arcl_num_flag,
pn.auto_rec_expcl_num_flag,
pn.cons_rec_agrterms_flag,
pn.location_code_separator,
pn.default_locn_area_flag,
pn.grouping_rule_id,
pn.gl_transfer_mode,
pn.submit_journal_import_flag,
pn.legacy_data_cutoff_date,
pn.default_user_view_code,
pn.extend_indexrent_term_flag,
pn.sysdate_for_adj_flag,
pn.sysdate_as_trx_date_flag,
pn.renorm_adj_acc_all_draft_flag,
pn.consolidate_adj_items_flag,
pn.calc_annualized_basis_code,
pn.allow_tenancy_overlap_flag,
pn.recalc_ir_on_acc_chg_flag,
pn.smallest_term_amount,
pn.incl_terms_by_default_flag
BULK COLLECT
INTO p_globals.org_id_t,
p_globals.set_of_books_name_t,
p_globals.chart_of_accounts_id_t,
p_globals.legal_entity_name_t,
p_globals.functional_currency_code_t,
p_globals.set_of_books_id_t,
p_globals.accounting_option_t,
p_globals.default_currency_conv_type_t,
p_globals.space_assign_sysdate_optn_t,
p_globals.multiple_tenancy_lease_t,
p_globals.auto_space_distribution_t,
p_globals.auto_comp_num_gen_t,
p_globals.auto_lease_num_gen_t,
p_globals.auto_index_num_gen_t,
p_globals.auto_var_rent_num_gen_t,
p_globals.auto_rec_agr_num_flag_t,
p_globals.auto_rec_exp_num_flag_t,
p_globals.auto_rec_arcl_num_flag_t,
p_globals.auto_rec_expcl_num_flag_t,
p_globals.cons_rec_agrterms_flag_t,
p_globals.location_code_separator_t,
p_globals.default_locn_area_flag_t,
p_globals.grouping_rule_id_t,
p_globals.gl_transfer_mode_t,
p_globals.submit_journal_import_flag_t,
p_globals.legacy_data_cutoff_date_t,
p_globals.default_user_view_code_t,
p_globals.extend_indexrent_term_flag_t,
p_globals.sysdate_for_adj_flag_t,
p_globals.sysdate_as_trx_date_flag_t,
p_globals.renorm_acc_all_draft_flag_t,
p_globals.consolidate_adj_items_flag_t,
p_globals.calc_annualized_basis_code_t,
p_globals.allow_tenancy_overlap_flag_t,
p_globals.recalc_ir_on_acc_chg_flag_t,
p_globals.smallest_term_amount_t,
p_globals.incl_terms_by_default_flag_t
FROM hr_legal_entities hr,
gl_sets_of_books gl,
pn_system_setup_options pn
WHERE pn_mo_cache_utils.check_access(pn.org_id) = 'Y'
AND gl.set_of_books_id = pn.set_of_books_id
AND hr.organization_id (+) = pn.org_id;
SELECT -3115,
gl.name,
gl.chart_of_accounts_id,
NULL,
gl.currency_code,
pn.set_of_books_id,
pn.accounting_option,
pn.default_currency_conv_type,
pn.space_assign_sysdate_optn,
pn.multiple_tenancy_lease,
pn.auto_space_distribution,
pn.auto_comp_num_gen,
pn.auto_lease_num_gen,
pn.auto_index_num_gen,
pn.auto_var_rent_num_gen,
pn.auto_rec_agr_num_flag,
pn.auto_rec_exp_num_flag,
pn.auto_rec_arcl_num_flag,
pn.auto_rec_expcl_num_flag,
pn.cons_rec_agrterms_flag,
pn.location_code_separator,
pn.default_locn_area_flag,
pn.grouping_rule_id,
pn.gl_transfer_mode,
pn.submit_journal_import_flag,
pn.legacy_data_cutoff_date,
pn.default_user_view_code,
pn.extend_indexrent_term_flag,
pn.sysdate_for_adj_flag,
pn.sysdate_as_trx_date_flag,
pn.renorm_adj_acc_all_draft_flag,
pn.consolidate_adj_items_flag,
pn.calc_annualized_basis_code,
pn.allow_tenancy_overlap_flag,
pn.recalc_ir_on_acc_chg_flag,
pn.smallest_term_amount,
pn.incl_terms_by_default_flag
BULK COLLECT
INTO p_globals.org_id_t,
p_globals.set_of_books_name_t,
p_globals.chart_of_accounts_id_t,
p_globals.legal_entity_name_t,
p_globals.functional_currency_code_t,
p_globals.set_of_books_id_t,
p_globals.accounting_option_t,
p_globals.default_currency_conv_type_t,
p_globals.space_assign_sysdate_optn_t,
p_globals.multiple_tenancy_lease_t,
p_globals.auto_space_distribution_t,
p_globals.auto_comp_num_gen_t,
p_globals.auto_lease_num_gen_t,
p_globals.auto_index_num_gen_t,
p_globals.auto_var_rent_num_gen_t,
p_globals.auto_rec_agr_num_flag_t,
p_globals.auto_rec_exp_num_flag_t,
p_globals.auto_rec_arcl_num_flag_t,
p_globals.auto_rec_expcl_num_flag_t,
p_globals.cons_rec_agrterms_flag_t,
p_globals.location_code_separator_t,
p_globals.default_locn_area_flag_t,
p_globals.grouping_rule_id_t,
p_globals.gl_transfer_mode_t,
p_globals.submit_journal_import_flag_t,
p_globals.legacy_data_cutoff_date_t,
p_globals.default_user_view_code_t,
p_globals.extend_indexrent_term_flag_t,
p_globals.sysdate_for_adj_flag_t,
p_globals.sysdate_as_trx_date_flag_t,
p_globals.renorm_acc_all_draft_flag_t,
p_globals.consolidate_adj_items_flag_t,
p_globals.calc_annualized_basis_code_t,
p_globals.allow_tenancy_overlap_flag_t,
p_globals.recalc_ir_on_acc_chg_flag_t,
p_globals.smallest_term_amount_t, --#@#Bug4291907
p_globals.incl_terms_by_default_flag_t
FROM gl_sets_of_books gl,
pn_system_setup_options pn
WHERE gl.set_of_books_id = pn.set_of_books_id;
SELECT gl.name set_of_books_name,
gl.chart_of_accounts_id chart_of_accounts_id,
hr.name legal_entity_name,
gl.currency_code functional_currency_code,
pn.set_of_books_id set_of_books_id,
pn.accounting_option accounting_option,
pn.default_currency_conv_type default_currency_conv_type,
pn.space_assign_sysdate_optn space_assign_sysdate_optn,
pn.multiple_tenancy_lease multiple_tenancy_lease,
pn.auto_comp_num_gen auto_comp_num_gen,
pn.auto_index_num_gen auto_index_num_gen,
pn.auto_lease_num_gen auto_lease_num_gen,
pn.auto_space_distribution auto_space_distribution,
pn.auto_var_rent_num_gen auto_var_rent_num_gen,
pn.auto_rec_agr_num_flag auto_rec_agr_num_flag,
pn.auto_rec_exp_num_flag auto_rec_exp_num_flag,
pn.auto_rec_arcl_num_flag auto_rec_arcl_num_flag,
pn.auto_rec_expcl_num_flag auto_rec_expcl_num_flag,
pn.cons_rec_agrterms_flag cons_rec_agrterms_flag,
pn.location_code_separator location_code_separator,
pn.default_locn_area_flag default_locn_area_flag,
pn.grouping_rule_id grouping_rule_id,
pn.gl_transfer_mode gl_transfer_mode,
pn.submit_journal_import_flag submit_journal_import_flag,
pn.legacy_data_cutoff_date legacy_data_cutoff_date,
pn.default_user_view_code default_user_view_code,
pn.extend_indexrent_term_flag extend_indexrent_term_flag,
pn.sysdate_for_adj_flag sysdate_for_adj_flag,
pn.sysdate_as_trx_date_flag sysdate_as_trx_date_flag,
pn.renorm_adj_acc_all_draft_flag renorm_adj_acc_all_draft_flag,
pn.consolidate_adj_items_flag consolidate_adj_items_flag,
pn.calc_annualized_basis_code calc_annualized_basis_code,
pn.allow_tenancy_overlap_flag allow_tenancy_overlap_flag,
pn.recalc_ir_on_acc_chg_flag recalc_ir_on_acc_chg_flag,
pn.smallest_term_amount smallest_term_amount,
pn.incl_terms_by_default_flag incl_terms_by_default_flag
FROM hr_legal_entities hr,
gl_sets_of_books gl,
pn_system_setup_options pn
WHERE mo_global.check_access(pn.org_id) = 'Y'
AND gl.set_of_books_id = pn.set_of_books_id
AND hr.organization_id (+) = pn.org_id
AND nvl(pn.org_id,l_dummy_org_id) = p_id;
SELECT set_of_books_id,
accounting_option,
default_currency_conv_type,
space_assign_sysdate_optn,
multiple_tenancy_lease,
auto_comp_num_gen,
auto_index_num_gen,
auto_lease_num_gen,
auto_var_rent_num_gen,
auto_space_distribution,
auto_rec_agr_num_flag,
auto_rec_exp_num_flag,
auto_rec_arcl_num_flag,
auto_rec_expcl_num_flag,
cons_rec_agrterms_flag,
location_code_separator,
default_locn_area_flag,
grouping_rule_id,
gl_transfer_mode,
submit_journal_import_flag,
default_user_view_code,
extend_indexrent_term_flag,
TO_CHAR(legacy_data_cutoff_date, 'MM/DD/YYYY') legacy_cutoff_date,
sysdate_for_adj_flag,
sysdate_as_trx_date_flag,
renorm_adj_acc_all_draft_flag,
consolidate_adj_items_flag,
calc_annualized_basis_code,
allow_tenancy_overlap_flag,
recalc_ir_on_acc_chg_flag,
smallest_term_amount,
incl_terms_by_default_flag
FROM pn_system_setup_options
WHERE org_id = nvl(p_org_id, fnd_profile.value('ORG_ID'));