AR_CM_SOLD_SITE_USES_H_V
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: VIEW
Columns
Name |
---|
CM_SOLD_SITE_CUST_CAT_CODE CM_SOLD_SITE_CUST_ACCT_SITE_ID CM_SOLD_SITE_GLOBAL_ATTR1 CM_SOLD_SITE_GLOBAL_ATTR2 CM_SOLD_SITE_GLOBAL_ATTR3 CM_SOLD_SITE_GLOBAL_ATTR4 CM_SOLD_SITE_GLOBAL_ATTR5 CM_SOLD_SITE_GLOBAL_ATTR6 CM_SOLD_SITE_GLOBAL_ATTR7 CM_SOLD_SITE_GLOBAL_ATTR8 CM_SOLD_SITE_GLOBAL_ATTR9 CM_SOLD_SITE_GLOBAL_ATTR_CAT CM_SOLD_SITE_TRNSL_CUST_NAME CM_SOLD_SITE_GSA_INDICATOR CM_SOLD_SITE_LOCATION CM_SOLD_SITE_SITE_USE_CODE CM_SOLD_SITE_SITE_USE_ID CM_SOLD_SITE_TAX_REFERENCE CM_SOLD_USES_GLOBAL_ATTR1 CM_SOLD_USES_GLOBAL_ATTR_CAT CM_SOLD_USES_GSA_INDICATOR CM_SOLD_USES_LOCATION CM_SOLD_USES_SITE_USE_CODE CM_SOLD_USES_SITE_USE_ID CM_SOLD_USES_TAX_REFERENCE CM_SOLD_SITE_PARTY_SITE_ID LEDGER_ID EVENT_ID |
Query
SQL_Statement |
---|
SELECT /*+INDEX (he ar_xla_lines_extract_n1)*/ casa9.customer_category_code cm_sold_site_cust_cat_code , casa9.cust_acct_site_id cm_sold_site_cust_acct_site_id , null cm_sold_site_global_attr1 , null cm_sold_site_global_attr2 , null cm_sold_site_global_attr3 , null cm_sold_site_global_attr4 , null cm_sold_site_global_attr5 , null cm_sold_site_global_attr6 , null cm_sold_site_global_attr7 , null cm_sold_site_global_attr8 , null cm_sold_site_global_attr9 , null cm_sold_site_global_attr_cat , casa9.translated_customer_name cm_sold_site_trnsl_cust_name , csua8.gsa_indicator cm_sold_site_gsa_indicator , csua8.location cm_sold_site_location , csua8.site_use_code cm_sold_site_site_use_code , csua8.site_use_id cm_sold_site_site_use_id , null cm_sold_site_tax_reference , null CM_SOLD_USES_GLOBAL_ATTR1 , null CM_SOLD_USES_GLOBAL_ATTR_CAT , csua8.gsa_indicator CM_SOLD_USES_GSA_INDICATOR , csua8.location CM_SOLD_USES_LOCATION , csua8.site_use_code CM_SOLD_USES_SITE_USE_CODE , csua8.site_use_id CM_SOLD_USES_SITE_USE_ID , csua8.tax_reference CM_SOLD_USES_TAX_REFERENCE , casa9.party_site_id CM_SOLD_SITE_PARTY_SITE_ID , he.ledger_id ledger_id , he.event_id event_id FROM hz_cust_site_uses_all csua8 , hz_cust_acct_sites_all casa9 , ar_xla_lines_extract he WHERE he.level_flag = 'H' AND csua8.site_use_id = he.sold_site_use_id AND csua8.cust_acct_site_id = casa9.cust_acct_site_id |