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 |