[Home] [Help]
View: OE_RA_ADDRESSES_V
Product: | ONT - Order Management |
Description: | This view is used for validation of addresses. |
Implementation/DBA Data: |
APPS.OE_RA_ADDRESSES_V
|
View Text
SELECT ACCT_SITE.CUST_ACCT_SITE_ID
, ACCT_SITE.CUST_ACCOUNT_ID
, ACCT_SITE.BILL_TO_FLAG
, ACCT_SITE.SHIP_TO_FLAG
, ACCT_SITE.STATUS
, ACCT_SITE.ORG_ID
, ACCT_SITE.TERRITORY_ID
, ACCT_SITE.LAST_UPDATE_DATE
, ACCT_SITE.LAST_UPDATED_BY
, ACCT_SITE.LAST_UPDATE_LOGIN
, ACCT_SITE.CREATED_BY
, ACCT_SITE.CREATION_DATE
, ACCT_SITE.CUST_ACCOUNT_ID
FROM HZ_CUST_ACCT_SITES ACCT_SITE
Columns
Name |
ADDRESS_ID |
CUSTOMER_ID |
BILL_TO_FLAG |
SHIP_TO_FLAG |
STATUS |
ORG_ID |
TERRITORY_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
SOLD_TO_ORG_ID |