VIEW: APPS.ASO_PAYMENTS_V

Source

View Text - Preformatted

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 , DECODE(PAYMENT.PAYMENT_TYPE_CODE,'CREDIT_CARD',TRXN.CARD_NUMBER, PAYMENT.PAYMENT_REF_NUMBER) PAYMENT_REF_NUMBER, PAYMENT.PAYMENT_TERM_ID, I_TERMS.NAME, TRXN.CARD_ISSUER_CODE, TRXN.CARD_HOLDER_NAME, DECODE(trxn.encrypted, 'Y', NULL, to_date(trxn.masked_card_expirydate, 'MM/RRRR')) credit_card_expiration_date, TRXN.CARD_EXPIRATION_STATUS, TRXN.ENCRYPTED, TRXN.CARD_EXPIRED_FLAG, 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, PAYMENT.ATTRIBUTE16, PAYMENT.ATTRIBUTE17, PAYMENT.ATTRIBUTE18, PAYMENT.ATTRIBUTE19, PAYMENT.ATTRIBUTE20, PAYMENT.QUOTE_SHIPMENT_ID, PAYMENT.SECURITY_GROUP_ID, PAYMENT.OBJECT_VERSION_NUMBER, PAYMENT.CUST_PO_LINE_NUMBER, PAYMENT.PAYMENT_TERM_ID_FROM, PAYMENT.TRXN_EXTENSION_ID, TRXN.INSTRUMENT_SECURITY_CODE, TRXN.INSTR_ASSIGNMENT_ID, TRXN.INSTRUMENT_ID from RA_TERMS_VL I_TERMS, ASO_I_PAYMENT_TYPES_V I_TYPES, ASO_PAYMENTS PAYMENT, IBY_TRXN_EXTENSIONS_V TRXN WHERE PAYMENT.PAYMENT_TYPE_CODE = I_TYPES.PAYMENT_TYPE(+) AND PAYMENT.PAYMENT_TERM_ID = I_TERMS.TERM_ID(+) AND PAYMENT.TRXN_EXTENSION_ID = TRXN.TRXN_EXTENSION_ID (+)

View Text - HTML Formatted

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
, DECODE(PAYMENT.PAYMENT_TYPE_CODE
, 'CREDIT_CARD'
, TRXN.CARD_NUMBER
, PAYMENT.PAYMENT_REF_NUMBER) PAYMENT_REF_NUMBER
, PAYMENT.PAYMENT_TERM_ID
, I_TERMS.NAME
, TRXN.CARD_ISSUER_CODE
, TRXN.CARD_HOLDER_NAME
, DECODE(TRXN.ENCRYPTED
, 'Y'
, NULL
, TO_DATE(TRXN.MASKED_CARD_EXPIRYDATE
, 'MM/RRRR')) CREDIT_CARD_EXPIRATION_DATE
, TRXN.CARD_EXPIRATION_STATUS
, TRXN.ENCRYPTED
, TRXN.CARD_EXPIRED_FLAG
, 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
, PAYMENT.ATTRIBUTE16
, PAYMENT.ATTRIBUTE17
, PAYMENT.ATTRIBUTE18
, PAYMENT.ATTRIBUTE19
, PAYMENT.ATTRIBUTE20
, PAYMENT.QUOTE_SHIPMENT_ID
, PAYMENT.SECURITY_GROUP_ID
, PAYMENT.OBJECT_VERSION_NUMBER
, PAYMENT.CUST_PO_LINE_NUMBER
, PAYMENT.PAYMENT_TERM_ID_FROM
, PAYMENT.TRXN_EXTENSION_ID
, TRXN.INSTRUMENT_SECURITY_CODE
, TRXN.INSTR_ASSIGNMENT_ID
, TRXN.INSTRUMENT_ID
FROM RA_TERMS_VL I_TERMS
, ASO_I_PAYMENT_TYPES_V I_TYPES
, ASO_PAYMENTS PAYMENT
, IBY_TRXN_EXTENSIONS_V TRXN
WHERE PAYMENT.PAYMENT_TYPE_CODE = I_TYPES.PAYMENT_TYPE(+)
AND PAYMENT.PAYMENT_TERM_ID = I_TERMS.TERM_ID(+)
AND PAYMENT.TRXN_EXTENSION_ID = TRXN.TRXN_EXTENSION_ID (+)