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_GROUPS

Line 664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;

660: l_delimiter zx_fc_types_b.delimiter%type;
661: l_delimiter_prod_cat zx_fc_types_b.delimiter%type;
662:
663: --Bug#5112515
664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;
665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;
666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;
667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;
668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;

Line 665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;

661: l_delimiter_prod_cat zx_fc_types_b.delimiter%type;
662:
663: --Bug#5112515
664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;
665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;
666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;
667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;
668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;
669:

Line 666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;

662:
663: --Bug#5112515
664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;
665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;
666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;
667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;
668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;
669:
670: CURSOR c_grp_code_cus IS

Line 667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;

663: --Bug#5112515
664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;
665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;
666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;
667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;
668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;
669:
670: CURSOR c_grp_code_cus IS
671: SELECT TGR.TRANSACTION_NATURE ATTRIBUTE3,--TTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE3,

Line 668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;

664: l_transaction_nature JL_ZZ_AR_TX_GROUPS.TRANSACTION_NATURE%TYPE;
665: l_establishment_type JL_ZZ_AR_TX_GROUPS.ESTABLISHMENT_TYPE%TYPE;
666: l_contributor_type JL_ZZ_AR_TX_GROUPS.CONTRIBUTOR_TYPE%TYPE;
667: l_calculate_in_oe JL_ZZ_AR_TX_GROUPS.CALCULATE_IN_OE%TYPE;
668: l_group_tax_id JL_ZZ_AR_TX_GROUPS.GROUP_TAX_ID%TYPE;
669:
670: CURSOR c_grp_code_cus IS
671: SELECT TGR.TRANSACTION_NATURE ATTRIBUTE3,--TTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE3,
672: TGR.ESTABLISHMENT_TYPE ATTRIBUTE5,--OTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE5,

Line 677: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

673: TGR.TAX_CATEGORY_ID NUMERIC_ATTRIBUTE1,
674: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
675: TGR.CALCULATE_IN_OE,
676: TXC.TAX_CATEGORY
677: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
678: JL_ZZ_AR_TX_CATEG TXC
679: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
680: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
681: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,

Line 727: FROM JL_ZZ_AR_TX_GROUPS TGR ,

723: SELECT TGR.TRANSACTION_NATURE ATTRIBUTE3 ,
724: TGR.ESTABLISHMENT_TYPE ATTRIBUTE5 ,
725: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,
726: TGR.CALCULATE_IN_OE
727: FROM JL_ZZ_AR_TX_GROUPS TGR ,
728: JL_ZZ_AR_TX_CATEG TXC
729: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
730: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
731: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >=

Line 786: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

782: TGR.TAX_CATEGORY_ID NUMERIC_ATTRIBUTE1,
783: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
784: TGR.CALCULATE_IN_OE,
785: TXC.TAX_CATEGORY
786: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
787: JL_ZZ_AR_TX_CATEG TXC
788: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
789: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
790: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,

Line 837: FROM JL_ZZ_AR_TX_GROUPS TGR ,

833: SELECT TGR.TRANSACTION_NATURE ATTRIBUTE3 ,
834: TGR.ESTABLISHMENT_TYPE ATTRIBUTE5 ,
835: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,
836: TGR.CALCULATE_IN_OE
837: FROM JL_ZZ_AR_TX_GROUPS TGR ,
838: JL_ZZ_AR_TX_CATEG TXC
839: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
840: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
841: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >=

Line 1465: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

1461: TGR.TRANSACTION_NATURE,
1462: TGR.ESTABLISHMENT_TYPE,
1463: TGR.CONTRIBUTOR_TYPE,
1464: TXC.TAX_CATEGORY
1465: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
1466: JL_ZZ_AR_TX_CATEG TXC
1467: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
1468: AND TGR.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
1469: AND NVL(TXC.START_DATE_ACTIVE, ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE) <=