View: AR_CM_SHIP_TO_SITE_USES_S_V

Product:	AR - Receivables
Description:	credit memo ship to site shared extract
Implementation/DBA Data:	APPS.AR_CM_SHIP_TO_SITE_USES_S_V

View Text

SELECT CASA10.CUSTOMER_CATEGORY_CODE CM_SHIP_SITE_CUST_CAT_CODE
, CASA10.CUST_ACCT_SITE_ID CM_SHIP_SITE_CUST_ACCT_SITE_ID
, CASA10.GLOBAL_ATTRIBUTE1 CM_SHIP_SITE_GLOBAL_ATTR1
, CASA10.GLOBAL_ATTRIBUTE2 CM_SHIP_SITE_GLOBAL_ATTR2
, CASA10.GLOBAL_ATTRIBUTE3 CM_SHIP_SITE_GLOBAL_ATTR3
, CASA10.GLOBAL_ATTRIBUTE4 CM_SHIP_SITE_GLOBAL_ATTR4
, CASA10.GLOBAL_ATTRIBUTE5 CM_SHIP_SITE_GLOBAL_ATTR5
, CASA10.GLOBAL_ATTRIBUTE6 CM_SHIP_SITE_GLOBAL_ATTR6
, CASA10.GLOBAL_ATTRIBUTE7 CM_SHIP_SITE_GLOBAL_ATTR7
, CASA10.GLOBAL_ATTRIBUTE8 CM_SHIP_SITE_GLOBAL_ATTR8
, CASA10.GLOBAL_ATTRIBUTE9 CM_SHIP_SITE_GLOBAL_ATTR9
, CASA10.GLOBAL_ATTRIBUTE_CATEGORY CM_SHIP_SITE_GLOBAL_ATTR_CAT
, CASA10.TRANSLATED_CUSTOMER_NAME CM_SHIP_SITE_TRNSL_CUST_NAME
, CSUA9.GSA_INDICATOR CM_SHIP_SITE_GSA_INDICATOR
, CSUA9.LOCATION CM_SHIP_SITE_LOCATION
, CSUA9.SITE_USE_CODE CM_SHIP_SITE_SITE_USE_CODE
, CSUA9.SITE_USE_ID CM_SHIP_SITE_SITE_USE_ID
, CSUA9.TAX_REFERENCE CM_SHIP_SITE_TAX_REFERENCE
, T9.DESCRIPTION CM_SHIP_TERRITORY_DESCRIPTION
, T9.NAME CM_SHIP_TERRITORY_NAME
, T9.SEGMENT1 CM_SHIP_TERRITORY_SEGMENT1
, T9.SEGMENT10 CM_SHIP_TERRITORY_SEGMENT10
, T9.SEGMENT11 CM_SHIP_TERRITORY_SEGMENT11
, T9.SEGMENT12 CM_SHIP_TERRITORY_SEGMENT12
, T9.SEGMENT13 CM_SHIP_TERRITORY_SEGMENT13
, T9.SEGMENT14 CM_SHIP_TERRITORY_SEGMENT14
, T9.SEGMENT15 CM_SHIP_TERRITORY_SEGMENT15
, T9.SEGMENT16 CM_SHIP_TERRITORY_SEGMENT16
, T9.SEGMENT17 CM_SHIP_TERRITORY_SEGMENT17
, T9.SEGMENT18 CM_SHIP_TERRITORY_SEGMENT18
, T9.SEGMENT19 CM_SHIP_TERRITORY_SEGMENT19
, T9.SEGMENT2 CM_SHIP_TERRITORY_SEGMENT2
, T9.SEGMENT20 CM_SHIP_TERRITORY_SEGMENT20
, T9.SEGMENT3 CM_SHIP_TERRITORY_SEGMENT3
, T9.SEGMENT4 CM_SHIP_TERRITORY_SEGMENT4
, T9.SEGMENT5 CM_SHIP_TERRITORY_SEGMENT5
, T9.SEGMENT6 CM_SHIP_TERRITORY_SEGMENT6
, T9.SEGMENT7 CM_SHIP_TERRITORY_SEGMENT7
, T9.SEGMENT8 CM_SHIP_TERRITORY_SEGMENT8
, T9.SEGMENT9 CM_SHIP_TERRITORY_SEGMENT9
, T9.TERRITORY_ID CM_SHIP_TERRITORY_ID
, CSUA9.GLOBAL_ATTRIBUTE1 CM_SHIP_USES_GLOBAL_ATTR1
, CSUA9.GLOBAL_ATTRIBUTE_CATEGORY CM_SHIP_USES_GLOBAL_ATTR_CAT
, CSUA9.GSA_INDICATOR CM_SHIP_USES_GSA_INDICATOR
, CSUA9.LOCATION CM_SHIP_USES_LOCATION
, CSUA9.SITE_USE_CODE CM_SHIP_USES_SITE_USE_CODE
, CSUA9.SITE_USE_ID CM_SHIP_USES_SITE_USE_ID
, CSUA9.TAX_REFERENCE CM_SHIP_USES_TAX_REFERENCE
, CASA10.PARTY_SITE_ID CM_SHIP_SITE_PARTY_SITE_ID
, HE.EVENT_ID EVENT_ID
FROM HZ_CUST_SITE_USES_ALL CSUA9
, HZ_CUST_ACCT_SITES_ALL CASA10
, RA_TERRITORIES T9
, AR_XLA_LINES_EXTRACT HE
WHERE HE.LEVEL_FLAG = 'H'
AND HE.EVENT_CLASS_CODE = 'CREDIT_MEMO'
AND CSUA9.SITE_USE_ID = HE.SHIP_SITE_USE_ID
AND CSUA9.CUST_ACCT_SITE_ID = CASA10.CUST_ACCT_SITE_ID
AND CSUA9.TERRITORY_ID = T9.TERRITORY_ID (+)

Columns