Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_CUST_TRD_PRFLS_V |
SELECT OTP.TRADE_PROFILE_ID
, OTP.OBJECT_VERSION_NUMBER
, OTP.LAST_UPDATE_DATE
, OTP.LAST_UPDATED_BY
, OTP.CREATION_DATE
, OTP.CREATED_BY
, OTP.LAST_UPDATE_LOGIN
, OTP.REQUEST_ID
, OTP.PROGRAM_APPLICATION_ID
, OTP.PROGRAM_UPDATE_DATE
, OTP.PROGRAM_ID
, OTP.CREATED_FROM
, OTP.PARTY_ID
, HP.PARTY_NAME
, OTP.CUST_ACCOUNT_ID
, HP.PARTY_NAME
, HCA.ACCOUNT_NUMBER
, OTP.CUST_ACCT_SITE_ID
, OTP.SITE_USE_ID
, HCSU.SITE_USE_CODE
, HCSU.LOCATION
, OTP.DAYS_DUE
, OTP.PAYMENT_METHOD
, OTP.VENDOR_ID
, PV. VENDOR_NAME
, OTP. VENDOR_SITE_ID
, OTP.VENDOR_SITE_CODE
, OTP.AUTOPAY_FLAG
, OTP.AUTOPAY_PERIODICITY
, OTP.AUTOPAY_PERIODICITY_TYPE
, OTP.CLAIM_THRESHOLD
, OTP.CLAIM_CURRENCY
, OTP.DISCOUNT_TYPE
, OTP.PRINT_FLAG
, OTP.INTERNET_DEAL_VIEW_FLAG
, OTP.INTERNET_CLAIMS_FLAG
, OTP.LAST_PAID_DATE
, OTP.CONTEXT
, OTP.ATTRIBUTE_CATEGORY
, OTP.ATTRIBUTE1
, OTP.ATTRIBUTE2
, OTP.ATTRIBUTE3
, OTP.ATTRIBUTE4
, OTP.ATTRIBUTE5
, OTP.ATTRIBUTE6
, OTP.ATTRIBUTE7
, OTP.ATTRIBUTE8
, OTP.ATTRIBUTE9
, OTP.ATTRIBUTE10
, OTP.ATTRIBUTE11
, OTP.ATTRIBUTE12
, OTP.ATTRIBUTE13
, OTP.ATTRIBUTE14
, OTP.ATTRIBUTE15
, OTP.ORG_ID
FROM OZF_CUST_TRD_PRFLS OTP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES HCSU
, HZ_PARTIES HP
, PO_VENDORS PV
WHERE OTP.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND OTP.SITE_USE_ID = HCSU.SITE_USE_ID
AND OTP.PARTY_ID = HP.PARTY_ID
AND OTP.VENDOR_ID = PV.VENDOR_ID(+)