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 226: FROM hz_cust_acct_sites

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

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

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

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

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

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

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

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

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