VIEW: APPS.OE_SOLD_TO_ORGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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