DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF_COMMON dependencies on JL_ZZ_AR_TX_CATEG_ALL

Line 654: from jl_zz_ar_tx_categ_all

650: WHEN codes.global_attribute_category IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
651: 'JL.BR.ARXSUVAT.Tax Information',
652: 'JL.CO.ARXSUVAT.AR_VAT_TAX')
653: THEN (select tax_category
654: from jl_zz_ar_tx_categ_all
655: where TO_CHAR(tax_category_id) = codes.global_attribute1
656: and org_id = codes.org_id)
657: ELSE
658: NULL

Line 777: from jl_zz_ar_tx_categ_all

773: WHEN codes.global_attribute_category IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
774: 'JL.BR.ARXSUVAT.Tax Information',
775: 'JL.CO.ARXSUVAT.AR_VAT_TAX')
776: THEN (select tax_category
777: from jl_zz_ar_tx_categ_all
778: where TO_CHAR(tax_category_id) = codes.global_attribute1
779: and org_id = codes.org_id)
780: ELSE
781: NULL

Line 934: from jl_zz_ar_tx_categ_all

930: WHEN codes.global_attribute_category IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
931: 'JL.BR.ARXSUVAT.Tax Information',
932: 'JL.CO.ARXSUVAT.AR_VAT_TAX')
933: THEN (select tax_category
934: from jl_zz_ar_tx_categ_all
935: where TO_CHAR(tax_category_id) = codes.global_attribute1
936: and org_id = codes.org_id)
937: ELSE
938: NULL

Line 1053: from jl_zz_ar_tx_categ_all

1049: WHEN codes.global_attribute_category IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
1050: 'JL.BR.ARXSUVAT.Tax Information',
1051: 'JL.CO.ARXSUVAT.AR_VAT_TAX')
1052: THEN (select tax_category
1053: from jl_zz_ar_tx_categ_all
1054: where TO_CHAR(tax_category_id) = codes.global_attribute1
1055: and org_id = codes.org_id)
1056: ELSE
1057: NULL

Line 1314: from jl_zz_ar_tx_categ_all

1310: WHEN ar_codes.global_attribute_category IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
1311: 'JL.BR.ARXSUVAT.Tax Information',
1312: 'JL.CO.ARXSUVAT.AR_VAT_TAX')
1313: THEN (select tax_category
1314: from jl_zz_ar_tx_categ_all
1315: where TO_CHAR(tax_category_id) = ar_codes.global_attribute1
1316: and org_id = ar_codes.org_id)
1317: ELSE
1318: NULL