eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_FC_CODES_DENORM_B

Line 215: zx_fc_codes_denorm_b denorm

211: Cursor c_trxbizcat_fiscalclass is
212: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
213: from zx_fc_codes_categ_assoc assoc,
214: zx_fc_types_b fctypes,
215: zx_fc_codes_denorm_b denorm
216: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
217: and fctypes.classification_type_code = p_fsc_rec.classification_type
218: and assoc.Classification_Code_Concat = p_fsc_rec.condition_value
219: and assoc.trans_business_categ_type_code = 'TRX_BUSINESS_CATEGORY'

Line 243: zx_fc_codes_denorm_b denorm

239: Cursor c_parent_trxbizcat_fiscalclass is
240: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
241: from zx_fc_codes_categ_assoc assoc,
242: zx_fc_types_b fctypes,
243: zx_fc_codes_denorm_b denorm
244: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
245: and fctypes.classification_type_code = p_fsc_rec.classification_type
246: and assoc.Classification_Code_Concat = p_fsc_rec.condition_value
247: and denorm.CONCAT_CLASSIF_CODE = p_fsc_rec.condition_value

Line 1246: from Zx_Fc_Codes_Denorm_B

1242: segment4,
1243: segment5,
1244: effective_from,
1245: effective_to
1246: from Zx_Fc_Codes_Denorm_B
1247: where Classification_Type_Categ_Code = p_fsc_cat_rec.classification_category
1248: and classification_type_code = p_fsc_cat_rec.classification_type
1249: and concat_classif_code = p_fsc_cat_rec.parameter_value
1250: and p_fsc_cat_rec.tax_determine_date between effective_from and nvl(effective_to, p_fsc_cat_rec.tax_determine_date);

Line 1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;

1255: where Classification_Type_Categ_Code = p_fsc_cat_rec.classification_category
1256: and classification_type_code = p_fsc_cat_rec.classification_type;
1257:
1258: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;

Line 1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;

1256: and classification_type_code = p_fsc_cat_rec.classification_type;
1257:
1258: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;

Line 1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;

1257:
1258: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;
1265: l_effective_to date;

Line 1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;

1258: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;
1265: l_effective_to date;
1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;

Line 1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;

1259: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1260: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1261: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;
1265: l_effective_to date;
1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1267: l_delimiter zx_fc_types_b.delimiter%type;

Line 1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;

1262: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;
1265: l_effective_to date;
1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1267: l_delimiter zx_fc_types_b.delimiter%type;
1268: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1269:
1270: -- Logging Infra

Line 1268: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;

1264: l_effective_from date;
1265: l_effective_to date;
1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1267: l_delimiter zx_fc_types_b.delimiter%type;
1268: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1269:
1270: -- Logging Infra
1271: l_procedure_name CONSTANT VARCHAR2(30) := 'get_prod_trx_cate_value';
1272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;