APPS.ZX_VALIDATE_API_PKG dependencies on ZX_FC_USER_DEFINED_V

Line 3992: FROM ZX_FC_USER_DEFINED_V

3988: -- Check for user defined code exists
3989: nvl2(lines_gt.user_defined_fisc_class,
3990: CASE WHEN (NOT EXISTS
3991: (SELECT 1
3992: FROM ZX_FC_USER_DEFINED_V
3993: WHERE classification_code = lines_gt.user_defined_fisc_class
3994: AND (country_code IS NULL
3995: OR country_code = header.default_taxation_country)))
3996: THEN 'Y'

Line 4005: FROM ZX_FC_USER_DEFINED_V

4001: -- Check for user defined code Effectivity
4002: CASE WHEN lines_gt.user_defined_fisc_class IS NOT NULL AND
4003: (EXISTS
4004: (SELECT 1
4005: FROM ZX_FC_USER_DEFINED_V
4006: WHERE classification_code = lines_gt.user_defined_fisc_class
4007: AND (country_code IS NULL
4008: OR country_code = header.default_taxation_country)))
4009: THEN CASE WHEN (NOT EXISTS

Line 4011: FROM ZX_FC_USER_DEFINED_V

4007: AND (country_code IS NULL
4008: OR country_code = header.default_taxation_country)))
4009: THEN CASE WHEN (NOT EXISTS
4010: (SELECT 1
4011: FROM ZX_FC_USER_DEFINED_V
4012: WHERE classification_code = lines_gt.user_defined_fisc_class
4013: AND (country_code IS NULL
4014: OR country_code = header.default_taxation_country)
4015: AND nvl(lines_gt.trx_line_date, header.trx_date)

Line 4030: FROM ZX_FC_USER_DEFINED_V

4026: -- Check for user defined code Country Consistency
4027: CASE WHEN lines_gt.user_defined_fisc_class IS NOT NULL AND
4028: (EXISTS
4029: (SELECT 1
4030: FROM ZX_FC_USER_DEFINED_V
4031: WHERE classification_code = lines_gt.user_defined_fisc_class
4032: AND country_code IS NOT NULL))
4033: THEN CASE WHEN (NOT EXISTS
4034: (SELECT 1

Line 4035: FROM ZX_FC_USER_DEFINED_V

4031: WHERE classification_code = lines_gt.user_defined_fisc_class
4032: AND country_code IS NOT NULL))
4033: THEN CASE WHEN (NOT EXISTS
4034: (SELECT 1
4035: FROM ZX_FC_USER_DEFINED_V
4036: WHERE classification_code = lines_gt.user_defined_fisc_class
4037: AND country_code IS NOT NULL
4038: AND country_code = header.default_taxation_country))
4039: THEN 'Y'