eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS

Line 689: FROM JL_ZZ_AR_TX_ATT_CLS ATC

685: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
686: AND TXC.END_DATE_ACTIVE >= ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
687: AND TXC.TAX_RULE_SET = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1
688: AND EXISTS (SELECT ATC.TAX_ATTRIBUTE_VALUE
689: FROM JL_ZZ_AR_TX_ATT_CLS ATC
690: WHERE TGR.ESTABLISHMENT_TYPE = ATC.TAX_ATTRIBUTE_VALUE
691: AND ATC.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
692: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
693: AND ATC.TAX_ATTRIBUTE_TYPE = 'ORGANIZATION_ATTRIBUTE'

Line 708: FROM JL_ZZ_AR_TX_ATT_CLS ATC

704: AND CTA.ENABLED_FLAG = 'Y'
705: AND TGR.CONTRIBUTOR_TYPE = CTA.TAX_ATTRIBUTE_VALUE
706: AND nvl(tgr.org_id,-99) = nvl(cta.org_id,-99)) --Bugfix 2367111
707: AND EXISTS (SELECT ATC.TAX_ATTRIBUTE_VALUE
708: FROM JL_ZZ_AR_TX_ATT_CLS ATC
709: WHERE TGR.TRANSACTION_NATURE = ATC.TAX_ATTRIBUTE_VALUE
710: AND ATC.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
711: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
712: AND ATC.TAX_ATTRIBUTE_TYPE = 'TRANSACTION_ATTRIBUTE'

Line 742: FROM JL_ZZ_AR_TX_ATT_CLS ATC

738: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE) <=
739: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
740: AND TXC.END_DATE_ACTIVE >= ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
741: AND EXISTS (SELECT ATC.TAX_ATTRIBUTE_VALUE
742: FROM JL_ZZ_AR_TX_ATT_CLS ATC
743: WHERE TGR.ESTABLISHMENT_TYPE = ATC.TAX_ATTRIBUTE_VALUE
744: AND ATC.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
745: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
746: AND TXC.TAX_CATEGORY_ID =

Line 766: FROM JL_ZZ_AR_TX_ATT_CLS ATC

762: AND CTA.TAX_ATTRIBUTE_NAME = TXC.CUS_TAX_ATTRIBUTE
763: AND CTA.ENABLED_FLAG = 'Y'
764: AND TGR.CONTRIBUTOR_TYPE = CTA.TAX_ATTRIBUTE_VALUE )
765: AND EXISTS (SELECT ATC.TAX_ATTRIBUTE_VALUE
766: FROM JL_ZZ_AR_TX_ATT_CLS ATC
767: WHERE TGR.TRANSACTION_NATURE = ATC.TAX_ATTRIBUTE_VALUE
768: AND ATC.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
769: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
770: AND TXC.TAX_CATEGORY_ID =

Line 798: FROM JL_ZZ_AR_TX_ATT_CLS ATC

794: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
795: AND TXC.END_DATE_ACTIVE >= ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
796: AND TXC.TAX_RULE_SET = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1
797: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
798: FROM JL_ZZ_AR_TX_ATT_CLS ATC
799: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
800: AND TGR.ESTABLISHMENT_TYPE = ATC.TAX_ATTRIBUTE_VALUE
801: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
802: AND ATC.TAX_ATTRIBUTE_TYPE = 'ORGANIZATION_ATTRIBUTE'

Line 808: FROM JL_ZZ_AR_TX_ATT_CLS ATC

804: AND ATC.TAX_ATTR_CLASS_CODE = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10
805: AND ATC.ENABLED_FLAG = 'Y'
806: AND nvl(tgr.org_id,-99) = nvl(atc.org_id,-99)) --Bugfix 2367111
807: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
808: FROM JL_ZZ_AR_TX_ATT_CLS ATC
809: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'CONTRIBUTOR_CLASS'
810: AND TGR.CONTRIBUTOR_TYPE = ATC.TAX_ATTRIBUTE_VALUE
811: AND ATC.TAX_ATTRIBUTE_TYPE = 'CONTRIBUTOR_ATTRIBUTE'
812: AND ATC.TAX_ATTR_CLASS_CODE = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6

Line 818: FROM JL_ZZ_AR_TX_ATT_CLS ATC

814: AND ATC.TAX_ATTRIBUTE_NAME = TXC.CUS_TAX_ATTRIBUTE
815: AND ATC.ENABLED_FLAG = 'Y'
816: AND nvl(tgr.org_id,-99) = nvl(atc.org_id,-99)) --Bugfix 2367111
817: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
818: FROM JL_ZZ_AR_TX_ATT_CLS ATC
819: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
820: AND TGR.TRANSACTION_NATURE = ATC.TAX_ATTRIBUTE_VALUE
821: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
822: AND ATC.TAX_ATTRIBUTE_TYPE = 'TRANSACTION_ATTRIBUTE'

Line 852: FROM JL_ZZ_AR_TX_ATT_CLS ATC

848: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
849: AND TXC.END_DATE_ACTIVE >= ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE
850: AND TXC.TAX_RULE_SET = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1
851: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
852: FROM JL_ZZ_AR_TX_ATT_CLS ATC
853: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
854: AND TGR.ESTABLISHMENT_TYPE = ATC.TAX_ATTRIBUTE_VALUE
855: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
856: AND TXC.TAX_CATEGORY_ID =

Line 863: FROM JL_ZZ_AR_TX_ATT_CLS ATC

859: AND ATC.TAX_ATTRIBUTE_NAME = TXC.ORG_TAX_ATTRIBUTE
860: AND ATC.TAX_ATTR_CLASS_CODE = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10
861: AND ATC.ENABLED_FLAG = 'Y')
862: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
863: FROM JL_ZZ_AR_TX_ATT_CLS ATC
864: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'CONTRIBUTOR_CLASS'
865: AND TGR.CONTRIBUTOR_TYPE = ATC.TAX_ATTRIBUTE_VALUE
866: AND ATC.TAX_ATTRIBUTE_TYPE = 'CONTRIBUTOR_ATTRIBUTE'
867: AND ATC.TAX_ATTR_CLASS_CODE =

Line 875: FROM JL_ZZ_AR_TX_ATT_CLS ATC

871: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern1
872: AND ATC.TAX_ATTRIBUTE_NAME = TXC.CUS_TAX_ATTRIBUTE
873: AND ATC.ENABLED_FLAG = 'Y' )
874: AND EXISTS ( SELECT ATC.TAX_ATTRIBUTE_VALUE
875: FROM JL_ZZ_AR_TX_ATT_CLS ATC
876: WHERE ATC.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
877: AND TGR.TRANSACTION_NATURE = ATC.TAX_ATTRIBUTE_VALUE
878: AND ATC.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
879: AND TXC.TAX_CATEGORY_ID =

Line 1302: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');

1298: END LOOP;
1299: ELSE
1300: -- Override of Customer Site Profile is NOT set to 'Y'
1301: IF (g_level_statement >= g_current_runtime_level ) THEN
1302: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1303: END IF;
1304: -- Fetch Tax Group details
1305: FOR c_grp_code_att_rec IN c_grp_code_att
1306: LOOP

Line 1451: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;

1447: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','***Reason(s) for Unsuccessful group expansion***');
1448: END IF;
1449:
1450: DECLARE
1451: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1452: l_ota_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1453: l_cta_attrib_value jl_zz_ar_tx_cus_cls.tax_attribute_value%type;
1454:
1455: CURSOR c_tax_categ IS

Line 1452: l_ota_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;

1448: END IF;
1449:
1450: DECLARE
1451: l_tta_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1452: l_ota_attrib_value jl_zz_ar_tx_att_cls.tax_attribute_value%type;
1453: l_cta_attrib_value jl_zz_ar_tx_cus_cls.tax_attribute_value%type;
1454:
1455: CURSOR c_tax_categ IS
1456: SELECT TGR.TAX_CATEGORY_ID,

Line 1492: FROM JL_ZZ_AR_TX_ATT_CLS_ALL TTA --Bugfix 2367111

1488: -- Match with Attribute Value of Transaction Class Type
1489: BEGIN
1490: SELECT TTA.TAX_ATTRIBUTE_VALUE
1491: INTO l_tta_attrib_value
1492: FROM JL_ZZ_AR_TX_ATT_CLS_ALL TTA --Bugfix 2367111
1493: WHERE TTA.TAX_ATTRIBUTE_VALUE
1494: = c_tax_categ_rec.transaction_nature
1495: AND TTA.TAX_ATTR_CLASS_TYPE = 'TRANSACTION_CLASS'
1496: AND TTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id

Line 1536: FROM JL_ZZ_AR_TX_ATT_CLS_ALL OTA --Bugfix 2367111

1532: -- Match with Attribute Value of Organization Class Type
1533: BEGIN
1534: SELECT OTA.TAX_ATTRIBUTE_VALUE
1535: INTO l_ota_attrib_value
1536: FROM JL_ZZ_AR_TX_ATT_CLS_ALL OTA --Bugfix 2367111
1537: WHERE OTA.TAX_ATTRIBUTE_VALUE = c_tax_categ_rec.establishment_type
1538: AND OTA.TAX_ATTR_CLASS_TYPE = 'ORGANIZATION_CLASS'
1539: AND OTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id
1540: AND OTA.TAX_ATTRIBUTE_TYPE = 'ORGANIZATION_ATTRIBUTE'

Line 1590: FROM JL_ZZ_AR_TX_ATT_CLS_ALL CTA --Bugfix 2367111

1586: AND nvl(cta.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1587: ELSE
1588: SELECT CTA.TAX_ATTRIBUTE_VALUE
1589: INTO l_cta_attrib_value
1590: FROM JL_ZZ_AR_TX_ATT_CLS_ALL CTA --Bugfix 2367111
1591: WHERE CTA.TAX_ATTRIBUTE_VALUE = c_tax_categ_rec.contributor_type
1592: AND CTA.TAX_ATTR_CLASS_TYPE = 'CONTRIBUTOR_CLASS'
1593: AND CTA.TAX_ATTRIBUTE_TYPE = 'CONTRIBUTOR_ATTRIBUTE'
1594: AND CTA.TAX_CATEGORY_ID = c_tax_categ_rec.tax_category_id

Line 1730: 'Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');

1726: -- Override of Customer Site Profile is NOT set to 'Y'
1727: IF (g_level_statement >= g_current_runtime_level ) THEN
1728: FND_LOG.STRING(g_level_statement,
1729: 'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG',
1730: 'Using JL_ZZ_AR_TX_ATT_CLS for Contributor Class');
1731: END IF;
1732:
1733: OPEN c_grp_code_att_cm;
1734: FETCH c_grp_code_att_cm INTO