DOO_ORDER_ADDRESSES_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
ADDRESS_ID ADDRESS_USE_TYPE CONTACT_ID CREATED_BY CREATION_DATE CUST_ACCOUNT_CONTACT_ID CUST_ACCT_ID CUST_ACCT_SITE_USE_ID FULFILL_LINE_ID HEADER_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PARTY_ID PARTY_SITE_ID PREF_CONTACT_POINT_ID

Query

SQL_Statement
SELECT DOA.ADDRESS_ID, DOA.ADDRESS_USE_TYPE, DOA.CONTACT_ID, DOA.CREATED_BY, DOA.CREATION_DATE, DOA.CUST_ACCOUNT_CONTACT_ID, DOA.CUST_ACCT_ID, DOA.CUST_ACCT_SITE_USE_ID, DOA.FULFILL_LINE_ID, DOA.HEADER_ID, DOA.LAST_UPDATED_BY, DOA.LAST_UPDATE_DATE, DOA.LAST_UPDATE_LOGIN, DOA.PARTY_ID, DOA.PARTY_SITE_ID, DOA.PREF_CONTACT_POINT_ID FROM DOO_ORDER_ADDRESSES DOA