VIEW: APPS.ASO_OA_PAYMENTS_LINE_V

Source

View Text - Preformatted

SELECT PMT.PAYMENT_ID, PMT.CREATION_DATE, PMT.CREATED_BY, PMT.LAST_UPDATE_DATE, PMT.LAST_UPDATED_BY, PMT.LAST_UPDATE_LOGIN, PMT.REQUEST_ID, PMT.PROGRAM_APPLICATION_ID, PMT.PROGRAM_ID, PMT.PROGRAM_UPDATE_DATE, PMT.QUOTE_HEADER_ID, PMT.QUOTE_LINE_ID, PMT.PAYMENT_TYPE_CODE, DECODE(PMT.PAYMENT_TYPE_CODE,'CREDIT_CARD',TRXN.CARD_NUMBER, PMT.PAYMENT_REF_NUMBER) PAYMENT_REF_NUMBER, PMT.PAYMENT_OPTION, PMT.PAYMENT_TERM_ID, TRXN.CARD_ISSUER_CODE, TRXN.CARD_HOLDER_NAME, DECODE(trxn.encrypted, 'Y', to_date(NULL), to_date(trxn.masked_card_expirydate, 'MM/RRRR')) credit_card_expiration_date, trxn.card_expiration_status, trxn.encrypted, trxn.card_expired_flag, PMT.CREDIT_CARD_APPROVAL_CODE, PMT.CREDIT_CARD_APPROVAL_DATE, PMT.PAYMENT_AMOUNT, PMT.CUST_PO_LINE_NUMBER, PMT.ATTRIBUTE_CATEGORY, PMT.ATTRIBUTE1, PMT.ATTRIBUTE2, PMT.ATTRIBUTE3, PMT.ATTRIBUTE4, PMT.ATTRIBUTE5, PMT.ATTRIBUTE6, PMT.ATTRIBUTE7, PMT.ATTRIBUTE8, PMT.ATTRIBUTE9, PMT.ATTRIBUTE10, PMT.ATTRIBUTE11, PMT.ATTRIBUTE12, PMT.ATTRIBUTE13, PMT.ATTRIBUTE14, PMT.ATTRIBUTE15, PMT.ATTRIBUTE16, PMT.ATTRIBUTE17, PMT.ATTRIBUTE18, PMT.ATTRIBUTE19, PMT.ATTRIBUTE20, PMT.QUOTE_SHIPMENT_ID, PMT.SECURITY_GROUP_ID, PMT.OBJECT_VERSION_NUMBER, PMT.CUST_PO_NUMBER, PMT.PAYMENT_TERM_ID_FROM, 'S', PMT.TRXN_EXTENSION_ID, TRXN.INSTRUMENT_SECURITY_CODE, TRXN.INSTR_ASSIGNMENT_ID, TRXN.INSTRUMENT_ID FROM ASO_PAYMENTS PMT, IBY_TRXN_EXTENSIONS_V TRXN WHERE PMT.TRXN_EXTENSION_ID = TRXN.TRXN_EXTENSION_ID (+) AND QUOTE_LINE_ID is not null

View Text - HTML Formatted

SELECT PMT.PAYMENT_ID
, PMT.CREATION_DATE
, PMT.CREATED_BY
, PMT.LAST_UPDATE_DATE
, PMT.LAST_UPDATED_BY
, PMT.LAST_UPDATE_LOGIN
, PMT.REQUEST_ID
, PMT.PROGRAM_APPLICATION_ID
, PMT.PROGRAM_ID
, PMT.PROGRAM_UPDATE_DATE
, PMT.QUOTE_HEADER_ID
, PMT.QUOTE_LINE_ID
, PMT.PAYMENT_TYPE_CODE
, DECODE(PMT.PAYMENT_TYPE_CODE
, 'CREDIT_CARD'
, TRXN.CARD_NUMBER
, PMT.PAYMENT_REF_NUMBER) PAYMENT_REF_NUMBER
, PMT.PAYMENT_OPTION
, PMT.PAYMENT_TERM_ID
, TRXN.CARD_ISSUER_CODE
, TRXN.CARD_HOLDER_NAME
, DECODE(TRXN.ENCRYPTED
, 'Y'
, TO_DATE(NULL)
, TO_DATE(TRXN.MASKED_CARD_EXPIRYDATE
, 'MM/RRRR')) CREDIT_CARD_EXPIRATION_DATE
, TRXN.CARD_EXPIRATION_STATUS
, TRXN.ENCRYPTED
, TRXN.CARD_EXPIRED_FLAG
, PMT.CREDIT_CARD_APPROVAL_CODE
, PMT.CREDIT_CARD_APPROVAL_DATE
, PMT.PAYMENT_AMOUNT
, PMT.CUST_PO_LINE_NUMBER
, PMT.ATTRIBUTE_CATEGORY
, PMT.ATTRIBUTE1
, PMT.ATTRIBUTE2
, PMT.ATTRIBUTE3
, PMT.ATTRIBUTE4
, PMT.ATTRIBUTE5
, PMT.ATTRIBUTE6
, PMT.ATTRIBUTE7
, PMT.ATTRIBUTE8
, PMT.ATTRIBUTE9
, PMT.ATTRIBUTE10
, PMT.ATTRIBUTE11
, PMT.ATTRIBUTE12
, PMT.ATTRIBUTE13
, PMT.ATTRIBUTE14
, PMT.ATTRIBUTE15
, PMT.ATTRIBUTE16
, PMT.ATTRIBUTE17
, PMT.ATTRIBUTE18
, PMT.ATTRIBUTE19
, PMT.ATTRIBUTE20
, PMT.QUOTE_SHIPMENT_ID
, PMT.SECURITY_GROUP_ID
, PMT.OBJECT_VERSION_NUMBER
, PMT.CUST_PO_NUMBER
, PMT.PAYMENT_TERM_ID_FROM
, 'S'
, PMT.TRXN_EXTENSION_ID
, TRXN.INSTRUMENT_SECURITY_CODE
, TRXN.INSTR_ASSIGNMENT_ID
, TRXN.INSTRUMENT_ID
FROM ASO_PAYMENTS PMT
, IBY_TRXN_EXTENSIONS_V TRXN
WHERE PMT.TRXN_EXTENSION_ID = TRXN.TRXN_EXTENSION_ID (+)
AND QUOTE_LINE_ID IS NOT NULL