AR_CM_SOLD_SITE_USES_S

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 EVENT_ID LINE_NUMBER LEDGER_ID LANGUAGE

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

EVENT_ID

LINE_NUMBER

LEDGER_ID

LANGUAGE

Query

SQL_Statement
SELECT 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.event_id event_id , he.line_number line_number , he.ledger_id ledger_id , he.language language FROM hz_cust_site_uses_all csua8 , hz_cust_acct_sites_all casa9 , ar_xla_lines_extract he WHERE he.level_flag = 'H' AND he.event_class_code = 'CREDIT_MEMO' AND csua8.site_use_id = he.sold_site_use_id AND csua8.cust_acct_site_id = casa9.cust_acct_site_id AND (casa9.SET_ID = FND_SETID_UTILITY.GETSETID('HZ_CUSTOMER_ACCOUNT_SITE','BU', he.ORG_ID) OR casa9.SET_ID = 0) AND casa9.SET_ID = csua8.SET_ID

SQL_Statement

SELECT 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.event_id event_id ,

he.line_number line_number ,

he.ledger_id ledger_id ,

he.language language

FROM hz_cust_site_uses_all csua8 ,

hz_cust_acct_sites_all casa9 ,

ar_xla_lines_extract he

WHERE he.level_flag = 'H'

AND he.event_class_code = 'CREDIT_MEMO'

AND csua8.site_use_id = he.sold_site_use_id

AND csua8.cust_acct_site_id = casa9.cust_acct_site_id

AND (casa9.SET_ID = FND_SETID_UTILITY.GETSETID('HZ_CUSTOMER_ACCOUNT_SITE','BU', he.ORG_ID)

OR casa9.SET_ID = 0)

AND casa9.SET_ID = csua8.SET_ID