AR_RCT_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

RCT_SITE_CUST_ACCT_SITE_ID RCT_SITE_TRNSL_CUST_NAME RCT_SITE_GSA_INDICATOR RCT_SITE_LOCATION RCT_SITE_SITE_USE_CODE RCT_SITE_SITE_USE_ID RCT_SITE_TAX_REFERENCE RCT_SITE_CUST_CAT_CODE RCT_SITE_GLOBAL_ATTR1 RCT_SITE_GLOBAL_ATTR2 RCT_SITE_GLOBAL_ATTR3 RCT_SITE_GLOBAL_ATTR4 RCT_SITE_GLOBAL_ATTR5 RCT_SITE_GLOBAL_ATTR6 RCT_SITE_GLOBAL_ATTR7 RCT_SITE_GLOBAL_ATTR8 RCT_SITE_GLOBAL_ATTR9 RCT_SITE_GLOBAL_ATTR_CAT RCT_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Query

SQL_Statement

SELECT casa3.cust_acct_site_id rct_site_cust_acct_site_id , casa3.translated_customer_name rct_site_trnsl_cust_name , csua3.gsa_indicator rct_site_gsa_indicator , csua3.location rct_site_location , csua3.site_use_code rct_site_site_use_code , csua3.site_use_id rct_site_site_use_id , csua3.tax_reference rct_site_tax_reference , casa3.CUSTOMER_CATEGORY_CODE rct_site_cust_cat_code , null rct_site_global_attr1 , null rct_site_global_attr2 , null rct_site_global_attr3 , null rct_site_global_attr4 , null rct_site_global_attr5 , null rct_site_global_attr6 , null rct_site_global_attr7 , null rct_site_global_attr8 , null rct_site_global_attr9 , null rct_site_global_attr_cat , casa3.party_site_id rct_site_party_site_id , l.event_id event_id , l.line_number line_number , l.language language , l.ledger_id ledger_id FROM hz_cust_site_uses_all csua3 , hz_cust_acct_sites_all casa3 , ar_xla_lines_extract l WHERE l.level_flag = 'H' AND l.event_class_code = 'CREDIT_MEMO' AND csua3.site_use_id = l.paying_site_use_id AND csua3.cust_acct_site_id = casa3.cust_acct_site_id AND (casa3.SET_ID = FND_SETID_UTILITY.GETSETID('HZ_CUSTOMER_ACCOUNT_SITE','BU', l.ORG_ID) OR casa3.SET_ID = 0) AND casa3.SET_ID = csua3.SET_ID