APPS.ZX_VALIDATE_API_PKG dependencies on ZX_FC_PRODUCT_CATEGORIES_V

Line 1971: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,

1967: lines_gt.trx_level_type
1968: FROM ZX_TRX_HEADERS_GT header,
1969: ZX_EVNT_CLS_MAPPINGS evntmap,
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,

Line 3930: FROM ZX_FC_PRODUCT_CATEGORIES_V

3926: -- Check Product Category exists
3927: nvl2(lines_gt.product_category,
3928: CASE WHEN (NOT EXISTS
3929: (SELECT 1
3930: FROM ZX_FC_PRODUCT_CATEGORIES_V
3931: WHERE classification_code = lines_gt.product_category
3932: AND (country_code IS NULL
3933: OR country_code = header.default_taxation_country)
3934: )

Line 3947: FROM ZX_FC_PRODUCT_CATEGORIES_V

3943: --Bug 4703541
3944: CASE WHEN lines_gt.product_category IS NOT NULL AND
3945: (EXISTS
3946: (SELECT 1
3947: FROM ZX_FC_PRODUCT_CATEGORIES_V
3948: WHERE classification_code = lines_gt.product_category
3949: AND (country_code IS NULL
3950: OR country_code = header.default_taxation_country)))
3951: THEN CASE WHEN (NOT EXISTS

Line 3953: FROM ZX_FC_PRODUCT_CATEGORIES_V

3949: AND (country_code IS NULL
3950: OR country_code = header.default_taxation_country)))
3951: THEN CASE WHEN (NOT EXISTS
3952: (SELECT 1
3953: FROM ZX_FC_PRODUCT_CATEGORIES_V
3954: WHERE classification_code = lines_gt.product_category
3955: AND (country_code IS NULL
3956: OR country_code = header.default_taxation_country)
3957: AND nvl(lines_gt.trx_line_date, header.trx_date)

Line 3972: FROM ZX_FC_PRODUCT_CATEGORIES_V

3968: -- Check for Country Consistency
3969: CASE WHEN lines_gt.product_category IS NOT NULL AND
3970: (EXISTS
3971: (SELECT 1
3972: FROM ZX_FC_PRODUCT_CATEGORIES_V
3973: WHERE classification_code = lines_gt.product_category
3974: AND country_code IS NOT NULL))
3975: THEN CASE WHEN
3976: (NOT EXISTS

Line 3978: FROM ZX_FC_PRODUCT_CATEGORIES_V

3974: AND country_code IS NOT NULL))
3975: THEN CASE WHEN
3976: (NOT EXISTS
3977: (SELECT 1
3978: FROM ZX_FC_PRODUCT_CATEGORIES_V
3979: WHERE classification_code = lines_gt.product_category
3980: AND country_code IS NOT NULL
3981: AND country_code = header.default_taxation_country))
3982: THEN 'Y'

Line 4659: --ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,

4655: FROM
4656: ZX_TRX_HEADERS_GT header,
4657: ZX_EVNT_CLS_MAPPINGS evntmap,
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,