[Home] [Help]
View: ASO_I_CUST_ACCOUNTS_V
Product: | ASO - Order Capture |
Description: | view gives information regarding customer accounts |
Implementation/DBA Data: |
APPS.ASO_I_CUST_ACCOUNTS_V
|
View Text
SELECT ACCT.CUST_ACCOUNT_ID
, ACCT.PARTY_ID
, ACCT.ACCOUNT_NUMBER
, PART.PARTY_NAME
, ACCT.STATUS
, ACCT.ORDER_TYPE_ID
, ACCT.PRICE_LIST_ID
, ACCT.TAX_CODE
, ACCT.FOB_POINT FOB_CODE
, ACCT.FREIGHT_TERM
, ACCT.WAREHOUSE_ID
, ACCT.PAYMENT_TERM_ID
FROM HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES PART
WHERE PART.PARTY_ID = ACCT.PARTY_ID
Columns
Name |
CUST_ACCOUNT_ID |
PARTY_ID |
ACCOUNT_NUMBER |
CUSTOMER_NAME |
STATUS |
ORDER_TYPE_ID |
PRICE_LIST_ID |
TAX_CODE |
FOB_CODE |
FREIGHT_TERM |
WAREHOUSE_ID |
PAYMENT_TERM_ID |