View: OE_SOLD_TO_ORGS_V

Product:	ONT - Order Management
Description:	List of customers.
Implementation/DBA Data:	APPS.OE_SOLD_TO_ORGS_V

View Text

SELECT CUST_ACCT.CUST_ACCOUNT_ID ORGANIZATION_ID
, NULL BUSINESS_GROUP_ID
, NULL COST_ALLOCATION_KEYFLEX_ID
, NULL LOCATION_ID
, NULL SOFT_CODING_KEYFLEX_ID
, NULL START_DATE_ACTIVE
, PARTY.PARTY_NAME NAME
, NULL COMMENTS
, NULL END_DATE_ACTIVE
, NULL INTERNAL_EXTERNAL_FLAG
, NULL INTERNAL_ADDRESS_LINE
, NULL TYPE
, NULL REQUEST_ID
, NULL PROGRAM_APPLICATION_ID
, NULL PROGRAM_ID
, NULL PROGRAM_UPDATE_DATE
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, NULL ATTRIBUTE16
, NULL ATTRIBUTE17
, NULL ATTRIBUTE18
, NULL ATTRIBUTE19
, NULL ATTRIBUTE20
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATED_BY
, NULL LAST_UPDATE_LOGIN
, NULL CREATED_BY
, NULL CREATION_DATE
, CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NUMBER
, CUST_ACCT.STATUS
, CUST_ACCT.PRICE_LIST_ID
, CUST_ACCT.FOB_POINT FOB_POINT_CODE
, CUST_ACCT.FREIGHT_TERM FREIGHT_TERMS_CODE
, CUST_ACCT.SHIP_PARTIAL SHIP_PARTIAL_ALLOWED
, CUST_ACCT.SHIP_VIA SHIPPING_METHOD_CODE
, CUST_ACCT.ORDER_TYPE_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID=PARTY.PARTY_ID

Columns