[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sob.chart_of_accounts_id
FROM gl_sets_of_books sob,
financials_system_parameters fsp
WHERE fsp.set_of_books_id = sob.set_of_books_id;
SELECT taxable_flag
FROM mtl_system_items si
WHERE si.inventory_item_id = c_inventory_item_id
AND si.organization_id = nvl(c_ship_to_loc_org_id, c_item_org_id);
select enforce_tax_from_acct_flag,
enforce_tax_from_ref_doc_flag
from zx_evnt_cls_options
where application_id = c_application_id
and entity_code = c_entity_code
and event_class_code = c_event_class_code
and first_pty_org_id = (Select party_tax_profile_id
From zx_party_tax_profile
where party_id = c_org_id
and party_type_code = 'OU')
and sysdate >= effective_from
and sysdate <= nvl(effective_to,sysdate)
and enabled_flag = 'Y';
select taxable_flag
into l_shipment_taxable_flag
from po_line_locations
where line_location_id = p_line_location_id ;
func_short_name = 'AP_INSERT_FROM_DSET') THEN
l_tax_classification_code := p_templ_tax_classification_cd;
SELECT tc.lookup_code
FROM fnd_lookups tc,
po_line_locations ll
WHERE ll.line_location_id = p_line_location_id
AND tc.lookup_code = ll.tax_code_id -- replace with classification_code
AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(tc.enabled_flag,'Y') = 'Y';
SELECT input_tax_classification_code
FROM zx_lines_det_factors
WHERE application_id = c_ref_doc_application_id
AND entity_code = c_ref_doc_entity_code
AND event_class_code = c_ref_doc_event_class_code
AND trx_id = c_ref_doc_trx_id
AND trx_line_id = c_ref_doc_line_id
AND trx_level_type = c_ref_doc_trx_level_type;
SELECT vat_code, party_site_id
FROM ap_supplier_sites
WHERE vendor_site_id = c_vendor_site_id;
SELECT vs.tax_classification_code
FROM zx_party_tax_profile vs,
zx_input_classifications_v tc
WHERE vs.party_id = c_party_site_id
AND vs.party_type_code = 'THIRD_PARTY_SITE'
AND vs.tax_classification_code = tc.lookup_code
AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(tc.enabled_flag,'Y') = 'Y'
AND tc.org_id in (sysinfo.org_id,-99);
SELECT vat_code, party_id
FROM ap_suppliers
WHERE vendor_id = c_vendor_id;
SELECT v.tax_classification_code
FROM zx_party_tax_profile v,
zx_input_classifications_v tc
WHERE v.party_id = c_party_id
AND v.party_type_code = 'THIRD_PARTY'
AND v.tax_classification_code = tc.lookup_code
AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(tc.enabled_flag,'Y') = 'Y'
AND tc.org_id in (sysinfo.org_id,-99);
SELECT ptp.tax_classification_code
FROM zx_party_tax_profile ptp,
zx_input_classifications_v tc
WHERE ptp.party_tax_profile_id = c_ptp_id
AND ptp.tax_classification_code = tc.lookup_code
AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(tc.enabled_flag,'Y') = 'Y'
AND tc.org_id in (sysinfo.org_id,-99);
SELECT hr.tax_name
FROM hr_locations_all hr,
zx_input_classifications_v tc
WHERE hr.location_id = c_ship_to_loc_id
AND hr.tax_name = tc.lookup_code
AND tc.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
AND nvl(tc.enabled_flag,'Y') = 'Y'
AND tc.org_id in (sysinfo.org_id,-99);
SELECT si.purchasing_tax_code
FROM fnd_lookups tc,
mtl_system_items si
WHERE si.inventory_item_id = p_item_id
AND si.organization_id = nvl(p_ship_to_loc_org_id, p_item_org_id)
AND tc.lookup_code = si.purchasing_tax_code
AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(tc.enabled_flag,'Y') = 'Y';
statement := 'SELECT ' || l_app_column_name ||
' FROM gl_code_combinations cc' ||
' WHERE cc.code_combination_id = ' || p_code_combination_id;
statement := 'SELECT toa.allow_tax_code_override_flag, ' ||
'toa.tax_classification_code, ' ||
'toa.tax_class ' ||
'FROM zx_acct_tx_cls_defs_all toa, ' ||
'zx_input_classifications_v tc ' ||
'WHERE toa.account_segment_value = :l_account_seg_value ' ||
'AND (toa.org_id = :l_bind_org_id or toa.org_id = -1)' ||
'AND toa.tax_class = ''I'' ' ||
'AND tc.lookup_code = toa.tax_classification_code ' ||
'AND tc.lookup_type = ''ZX_INPUT_CLASSIFICATIONS'' ' ||
'AND nvl(tc.enabled_flag,''Y'') = ''Y'' ' ||
'AND tc.org_id in (:l_bind_org_id,-99) '||
'UNION ' ||
'SELECT toa.allow_tax_code_override_flag, ' ||
'toa.tax_classification_code, ' ||
'toa.tax_class ' ||
'FROM zx_acct_tx_cls_defs_all toa ' ||
'WHERE toa.account_segment_value = :l_account_seg_value ' ||
'AND ( toa.org_id = :l_bind_org_id or toa.org_id = -1 )' ||
'AND toa.tax_class = ''N'' ';
SELECT org_id,
use_tax_classification_flag,
tax_classification_code,
def_option_hier_1_code,
def_option_hier_2_code,
def_option_hier_3_code,
def_option_hier_4_code,
def_option_hier_5_code,
def_option_hier_6_code,
def_option_hier_7_code
FROM zx_product_options_all
WHERE org_id = c_org_id
AND application_id = c_application_id
AND event_class_mapping_id IS NULL;
SELECT event_class_mapping_id
FROM zx_evnt_cls_mappings
WHERE event_class_code = c_event_class_code
AND application_id = c_application_id
AND entity_code = c_entity_code;
SELECT org_id,
use_tax_classification_flag,
tax_classification_code,
def_option_hier_1_code,
def_option_hier_2_code,
def_option_hier_3_code,
def_option_hier_4_code,
def_option_hier_5_code,
def_option_hier_6_code,
def_option_hier_7_code
FROM zx_product_options_all
WHERE org_id = c_org_id
AND application_id = c_application_id
AND event_class_mapping_id = c_event_class_mapping_id;
SELECT status
FROM fnd_product_installations
WHERE application_id = c_application_id;
SELECT org_id,
use_tax_classification_flag,
tax_classification_code,
def_option_hier_1_code,
def_option_hier_2_code,
def_option_hier_3_code,
def_option_hier_4_code,
def_option_hier_5_code,
def_option_hier_6_code,
def_option_hier_7_code
FROM zx_product_options_all
WHERE org_id = c_org_id
AND application_id = c_application_id
AND event_class_mapping_id IS NULL;
SELECT org_id,
use_tax_classification_flag,
tax_classification_code,
def_option_hier_1_code,
def_option_hier_2_code,
def_option_hier_3_code,
def_option_hier_4_code,
def_option_hier_5_code,
def_option_hier_6_code,
def_option_hier_7_code
FROM zx_product_options_all
WHERE org_id = c_org_id
AND application_id = c_application_id
AND event_class_mapping_id IS NULL;
SELECT count(1)
FROM fnd_lookups
WHERE lookup_code = c_tax_classification_code
AND lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
AND nvl(enabled_flag,'Y') = 'Y';