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_AR_TX_LIB_PKG dependencies on HZ_CUST_ACCT_SITES

Line 225: FROM hz_cust_acct_sites

221:
222: BEGIN
223: SELECT global_attribute8
224: INTO l_contributor_class_code
225: FROM hz_cust_acct_sites
226: WHERE cust_acct_site_id = p_address_id;
227:
228: IF substr(p_contributor_class_code,1,30) <>
229: substr(l_contributor_class_code,1,30) THEN

Line 289: -- will update HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 with 'Y' if there are

285: -- be stored in Customer Site Profile (JL_ZZ_AR_TX_CUS_CLS)
286: --
287: -- A data cleanup script (JLZZUCAC) is provided to match existing records of
288: -- JL_ZZ_AR_TX_ATT_CLS and JL_ZZ_AR_TX_CUS_CLS for Contributor Class code and
289: -- will update HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 with 'Y' if there are
290: -- differences and will update with 'N' if there are NO differences where
291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --
293: -- For records whose GLOBAL_ATTRIBUTE8 is NOT NULL, Tax Engine would look

Line 291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.

287: -- A data cleanup script (JLZZUCAC) is provided to match existing records of
288: -- JL_ZZ_AR_TX_ATT_CLS and JL_ZZ_AR_TX_CUS_CLS for Contributor Class code and
289: -- will update HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9 with 'Y' if there are
290: -- differences and will update with 'N' if there are NO differences where
291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --
293: -- For records whose GLOBAL_ATTRIBUTE8 is NOT NULL, Tax Engine would look
294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and
295: -- JL_ZZ_AR_TX_ATT_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='N'

Line 294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and

290: -- differences and will update with 'N' if there are NO differences where
291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --
293: -- For records whose GLOBAL_ATTRIBUTE8 is NOT NULL, Tax Engine would look
294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and
295: -- JL_ZZ_AR_TX_ATT_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='N'
296: -- NULL value of GLOBAL_ATTRIBUTE9 will be interpreted as 'Y'
297:
298: return;

Line 295: -- JL_ZZ_AR_TX_ATT_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='N'

291: -- HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE8 is NOT NULL.
292: --
293: -- For records whose GLOBAL_ATTRIBUTE8 is NOT NULL, Tax Engine would look
294: -- JL_ZZ_AR_TX_CUS_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='Y' and
295: -- JL_ZZ_AR_TX_ATT_CLS if value of HZ_CUST_ACCT_SITES.GLOBAL_ATTRIBUTE9='N'
296: -- NULL value of GLOBAL_ATTRIBUTE9 will be interpreted as 'Y'
297:
298: return;
299: