DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_FC_PRODUCT_FISCAL_V

Line 1978: ZX_FC_PRODUCT_FISCAL_V fc_product

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
1979: --ZX_RATES_B rates --Commented for Bug#7504455--
1980: WHERE lines_gt.trx_id = header.trx_id
1981: AND fc_product.classification_code(+) = lines_gt.product_fisc_classification
1982: AND fc_prodcat.classification_code(+) = lines_gt.product_category

Line 4282: FROM ZX_FC_PRODUCT_FISCAL_V

4278: -- Check for product fiscal classification
4279: nvl2(lines_gt.product_fisc_classification,
4280: CASE WHEN (NOT EXISTS
4281: (SELECT 1
4282: FROM ZX_FC_PRODUCT_FISCAL_V
4283: WHERE classification_code = lines_gt.product_fisc_classification
4284: AND (country_code IS NULL
4285: OR country_code = header.default_taxation_country)))
4286: THEN 'Y'

Line 4665: --ZX_FC_PRODUCT_FISCAL_V fc_product

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--
4667: WHERE
4668: lines_gt.trx_id = header.trx_id
4669: and lines_gt.application_id = header.application_id