VIEW: APPS.OZF_CUST_TRD_PRFLS_V

Source

View Text - Preformatted

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, OTP.POS_WRITE_OFF_THRESHOLD, OTP.NEG_WRITE_OFF_THRESHOLD, OTP. UN_EARNED_PAY_ALLOW_TO, OTP.UN_EARNED_PAY_THOLD_TYPE, OTP.UN_EARNED_PAY_THOLD_AMOUNT, OTP.UN_EARNED_PAY_THOLD_FLAG, OTP.HEADER_TOLERANCE_OPERAND, OTP.HEADER_TOLERANCE_CALC_CODE, OTP.LINE_TOLERANCE_OPERAND, OTP.LINE_TOLERANCE_CALC_CODE 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(+)

View Text - HTML Formatted

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
, OTP.POS_WRITE_OFF_THRESHOLD
, OTP.NEG_WRITE_OFF_THRESHOLD
, OTP. UN_EARNED_PAY_ALLOW_TO
, OTP.UN_EARNED_PAY_THOLD_TYPE
, OTP.UN_EARNED_PAY_THOLD_AMOUNT
, OTP.UN_EARNED_PAY_THOLD_FLAG
, OTP.HEADER_TOLERANCE_OPERAND
, OTP.HEADER_TOLERANCE_CALC_CODE
, OTP.LINE_TOLERANCE_OPERAND
, OTP.LINE_TOLERANCE_CALC_CODE
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(+)