Product: | ASO - Order Capture |
---|---|
Description: | view based on aso_payments |
Implementation/DBA Data: | APPS.ASO_PAYMENTS_V |
SELECT PAYMENT.ROWID
, PAYMENT.PAYMENT_ID
, PAYMENT.QUOTE_HEADER_ID
, PAYMENT.QUOTE_LINE_ID
, PAYMENT.CREATION_DATE
, PAYMENT.CREATED_BY
, PAYMENT.LAST_UPDATE_DATE
, PAYMENT.LAST_UPDATED_BY
, PAYMENT.LAST_UPDATE_LOGIN
, PAYMENT.REQUEST_ID
, PAYMENT.PROGRAM_APPLICATION_ID
, PAYMENT.PROGRAM_ID
, PAYMENT.PROGRAM_UPDATE_DATE
, PAYMENT.PAYMENT_TYPE_CODE
, I_TYPES.PAYMENT_TYPE
, PAYMENT.PAYMENT_OPTION
, I_OPTIONS.PAYMENT_OPTION_MEANING
, PAYMENT.PAYMENT_REF_NUMBER
, PAYMENT.PAYMENT_TERM_ID
, I_TERMS.NAME
, PAYMENT.CREDIT_CARD_CODE
, PAYMENT.CREDIT_CARD_HOLDER_NAME
, PAYMENT.CREDIT_CARD_EXPIRATION_DATE
, PAYMENT.CREDIT_CARD_APPROVAL_CODE
, PAYMENT.CREDIT_CARD_APPROVAL_DATE
, PAYMENT.PAYMENT_AMOUNT
, PAYMENT.CUST_PO_NUMBER
, PAYMENT.ATTRIBUTE_CATEGORY
, PAYMENT.ATTRIBUTE1
, PAYMENT.ATTRIBUTE2
, PAYMENT.ATTRIBUTE3
, PAYMENT.ATTRIBUTE4
, PAYMENT.ATTRIBUTE5
, PAYMENT.ATTRIBUTE6
, PAYMENT.ATTRIBUTE7
, PAYMENT.ATTRIBUTE8
, PAYMENT.ATTRIBUTE9
, PAYMENT.ATTRIBUTE10
, PAYMENT.ATTRIBUTE11
, PAYMENT.ATTRIBUTE12
, PAYMENT.ATTRIBUTE13
, PAYMENT.ATTRIBUTE14
, PAYMENT.ATTRIBUTE15
FROM ASO_I_PAYMENT_OPTIONS_V I_OPTIONS
, ASO_I_PAYMENT_TERMS_V I_TERMS
, ASO_I_PAYMENT_TYPES_V I_TYPES
, ASO_PAYMENTS PAYMENT
WHERE PAYMENT.PAYMENT_TYPE_CODE = I_TYPES.PAYMENT_TYPE(+)
AND PAYMENT.PAYMENT_OPTION =I_OPTIONS.PAYMENT_OPTION(+)
AND PAYMENT.PAYMENT_TERM_ID = I_TERMS.PAYMENT_TERM_ID(+)