VRM_SHIP_TO_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

SHIP_SITE_CUST_CAT_CODE SHIP_SITE_CUST_ACCT_SITE_ID SHIP_SITE_GLOBAL_ATTR1 SHIP_SITE_GLOBAL_ATTR2 SHIP_SITE_GLOBAL_ATTR3 SHIP_SITE_GLOBAL_ATTR4 SHIP_SITE_GLOBAL_ATTR5 SHIP_SITE_GLOBAL_ATTR6 SHIP_SITE_GLOBAL_ATTR7 SHIP_SITE_GLOBAL_ATTR8 SHIP_SITE_GLOBAL_ATTR9 SHIP_SITE_GLOBAL_ATTR_CAT SHIP_SITE_TRNSL_CUST_NAME SHIP_SITE_GSA_INDICATOR SHIP_SITE_LOCATION SHIP_SITE_SITE_USE_CODE SHIP_SITE_SITE_USE_ID SHIP_SITE_TAX_REFERENCE SHIP_USES_GLOBAL_ATTR1 SHIP_USES_GLOBAL_ATTR_CAT SHIP_USES_GSA_INDICATOR SHIP_USES_LOCATION SHIP_USES_SITE_USE_CODE SHIP_USES_SITE_USE_ID SHIP_USES_TAX_REFERENCE SHIP_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX(l vrm_xla_lines_extract_n1)*/ casa5.customer_category_code ship_site_cust_cat_code , casa5.cust_acct_site_id ship_site_cust_acct_site_id , NULL ship_site_global_attr1, NULL ship_site_global_attr2, NULL ship_site_global_attr3, NULL ship_site_global_attr4, NULL ship_site_global_attr5, NULL ship_site_global_attr6, NULL ship_site_global_attr7, NULL ship_site_global_attr8, NULL ship_site_global_attr9, NULL ship_site_global_attr_cat, casa5.translated_customer_name ship_site_trnsl_cust_name , csua5.gsa_indicator ship_site_gsa_indicator , csua5.location ship_site_location , csua5.site_use_code ship_site_site_use_code , csua5.site_use_id ship_site_site_use_id , NULL ship_site_tax_reference , NULL SHIP_USES_GLOBAL_ATTR1 , NULL SHIP_USES_GLOBAL_ATTR_CAT , csua5.gsa_indicator SHIP_USES_GSA_INDICATOR , csua5.location SHIP_USES_LOCATION , csua5.site_use_code SHIP_USES_SITE_USE_CODE , csua5.site_use_id SHIP_USES_SITE_USE_ID , csua5.tax_reference SHIP_USES_TAX_REFERENCE , casa5.party_site_id SHIP_SITE_PARTY_SITE_ID , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM hz_cust_site_uses_all csua5 , hz_cust_acct_sites_all casa5 , vrm_xla_lines_extract_gt l WHERE csua5.site_use_id = l.ship_site_use_id AND csua5.cust_acct_site_id = casa5.cust_acct_site_id AND (casa5.SET_ID = FND_SETID_UTILITY.GETSETID('HZ_CUSTOMER_ACCOUNT_SITE','BU', l.ORG_ID) OR casa5.SET_ID = 0) AND casa5.SET_ID = csua5.SET_ID