APPS.ZX_VALIDATE_API_PKG dependencies on ZX_FC_BUSINESS_CATEGORIES_V

Line 1974: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,

1970: ZX_TRANSACTION_LINES_GT lines_gt,
1971: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1972: ZX_FC_CODES_B fc_user,
1973: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
1974: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
1975: ZX_FC_CODES_B fc_int,
1976: FND_LOOKUPS fnd,
1977: FND_TERRITORIES fnd_terr,
1978: ZX_FC_PRODUCT_FISCAL_V fc_product

Line 4079: FROM ZX_FC_BUSINESS_CATEGORIES_V

4075: -- Check for Transaction Business Category fc code exists
4076: nvl2(lines_gt.trx_business_category,
4077: CASE WHEN (NOT EXISTS
4078: (SELECT 1
4079: FROM ZX_FC_BUSINESS_CATEGORIES_V
4080: WHERE classification_code = DECODE(lines_gt.source_application_id,
4081: NULL, lines_gt.trx_business_category,
4082: DECODE(lines_gt.source_event_class_code,
4083: 'INTERCOMPANY_TRX',

Line 4108: FROM ZX_FC_BUSINESS_CATEGORIES_V

4104: --Bug 4703541
4105: CASE WHEN lines_gt.trx_business_category IS NOT NULL AND
4106: (EXISTS
4107: (SELECT 1
4108: FROM ZX_FC_BUSINESS_CATEGORIES_V
4109: WHERE classification_code =
4110: DECODE(lines_gt.source_application_id,
4111: NULL, lines_gt.trx_business_category,
4112: DECODE(lines_gt.source_event_class_code,

Line 4131: FROM ZX_FC_BUSINESS_CATEGORIES_V

4127: )
4128: THEN CASE WHEN
4129: (NOT EXISTS
4130: (SELECT 1
4131: FROM ZX_FC_BUSINESS_CATEGORIES_V
4132: WHERE classification_code = DECODE(lines_gt.source_application_id,
4133: NULL, lines_gt.trx_business_category,
4134: DECODE(lines_gt.source_event_class_code,
4135: 'INTERCOMPANY_TRX',

Line 4162: FROM ZX_FC_BUSINESS_CATEGORIES_V

4158: -- Check for Transaction Business Category code Country Consistency
4159: CASE WHEN lines_gt.trx_business_category IS NOT NULL AND
4160: (EXISTS
4161: (SELECT 1
4162: FROM ZX_FC_BUSINESS_CATEGORIES_V
4163: WHERE classification_code = DECODE(lines_gt.source_application_id,
4164: NULL, lines_gt.trx_business_category,
4165: DECODE(lines_gt.source_event_class_code,
4166: 'INTERCOMPANY_TRX',

Line 4179: FROM ZX_FC_BUSINESS_CATEGORIES_V

4175: )
4176: AND country_code IS NOT NULL))
4177: THEN CASE WHEN (NOT EXISTS
4178: (SELECT 1
4179: FROM ZX_FC_BUSINESS_CATEGORIES_V
4180: WHERE classification_code = DECODE(lines_gt.source_application_id,
4181: NULL, lines_gt.trx_business_category,
4182: DECODE(lines_gt.source_event_class_code,
4183: 'INTERCOMPANY_TRX',

Line 4662: --ZX_FC_BUSINESS_CATEGORIES_V fc_trx,

4658: ZX_TRANSACTION_LINES_GT lines_gt,
4659: --ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4660: --ZX_FC_CODES_B fc_user,
4661: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
4662: --ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
4663: --ZX_FC_CODES_B fc_int,
4664: FND_LOOKUPS fnd--,
4665: --ZX_FC_PRODUCT_FISCAL_V fc_product
4666: --ZX_RATES_B rates --Commented for Bug#7504455--