[Home] [Help]
View: OE_CUSTOMERS_ACTIVE_V
View Text
SELECT PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, CUST_ACCT.CUST_ACCOUNT_ID
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.GSA_INDICATOR_FLAG
, 'N') GSA_INDICATOR
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.STATUS = 'A'
Columns
Name |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_ID |
GSA_INDICATOR |