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.

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 1277: from Zx_Fc_Codes_Denorm_B

1273: segment4,
1274: segment5,
1275: effective_from,
1276: effective_to
1277: from Zx_Fc_Codes_Denorm_B
1278: where Classification_Type_Categ_Code = p_fsc_cat_rec.classification_category
1279: and classification_type_code = p_fsc_cat_rec.classification_type
1280: and concat_classif_code = p_fsc_cat_rec.parameter_value
1281: and p_fsc_cat_rec.tax_determine_date between effective_from and nvl(effective_to, p_fsc_cat_rec.tax_determine_date);

Line 1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;

1286: where Classification_Type_Categ_Code = p_fsc_cat_rec.classification_category
1287: and classification_type_code = p_fsc_cat_rec.classification_type;
1288:
1289: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;

Line 1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;

1287: and classification_type_code = p_fsc_cat_rec.classification_type;
1288:
1289: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1295: l_effective_from date;

Line 1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;

1288:
1289: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1295: l_effective_from date;
1296: l_effective_to date;

Line 1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;

1289: l_Classification_Code zx_fc_codes_b.Classification_Code%type;
1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1295: l_effective_from date;
1296: l_effective_to date;
1297: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;

Line 1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;

1290: l_segment1 Zx_Fc_Codes_Denorm_B.segment1%type;
1291: l_segment2 Zx_Fc_Codes_Denorm_B.segment1%type;
1292: l_segment3 Zx_Fc_Codes_Denorm_B.segment1%type;
1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1295: l_effective_from date;
1296: l_effective_to date;
1297: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1298: l_delimiter zx_fc_types_b.delimiter%type;

Line 1297: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;

1293: l_segment4 Zx_Fc_Codes_Denorm_B.segment1%type;
1294: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1295: l_effective_from date;
1296: l_effective_to date;
1297: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1298: l_delimiter zx_fc_types_b.delimiter%type;
1299: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1300:
1301: -- Logging Infra

Line 1299: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;

1295: l_effective_from date;
1296: l_effective_to date;
1297: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1298: l_delimiter zx_fc_types_b.delimiter%type;
1299: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1300:
1301: -- Logging Infra
1302: l_procedure_name CONSTANT VARCHAR2(30) := 'get_prod_trx_cate_value';
1303: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;