VIEW: PON.PON_EMD_TRANSACTIONS#

Source

View Text - Preformatted

select EMD_TRANSACTION_ID EMD_TRANSACTION_ID, EMD_TRANSACTION_GROUP_ID EMD_TRANSACTION_GROUP_ID, PARENT_EMD_TRANSACTION_ID PARENT_EMD_TRANSACTION_ID, AUCTION_HEADER_ID AUCTION_HEADER_ID, DOCUMENT_NUMBER DOCUMENT_NUMBER, SUPPLIER_SEQUENCE SUPPLIER_SEQUENCE, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, AMOUNT AMOUNT, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_DATE EXCHANGE_DATE, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, CASH_BEARER_NAME CASH_BEARER_NAME, BANK_NAME BANK_NAME, BANK_BRANCH_NAME BANK_BRANCH_NAME, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_ACCOUNT_CURRENCY BANK_ACCOUNT_CURRENCY, BANK_GURANTEE_NUMBER BANK_GURANTEE_NUMBER, CREDIT_CARD_NUM CREDIT_CARD_NUM, CARD_OWNER_ID CARD_OWNER_ID, NAME_ON_CARD NAME_ON_CARD, CARD_ISSUER_CODE CARD_ISSUER_CODE, PURCHASE_CARD_FLAG PURCHASE_CARD_FLAG, SINGLE_USE_FLAG SINGLE_USE_FLAG, TYPE_OF_CARD TYPE_OF_CARD, EXPIRY_DATE EXPIRY_DATE, CHEQUE_NUMBER CHEQUE_NUMBER, IN_FAVOR_OF IN_FAVOR_OF, DEMAND_DRAFT_NUM DEMAND_DRAFT_NUM, PAYABLE_AT PAYABLE_AT, ORG_ID ORG_ID, DOCUMENT_SUBMITTED DOCUMENT_SUBMITTED, JUSTIFICATION JUSTIFICATION, POSTED_TO_FINANCE POSTED_TO_FINANCE, DELETE_FLAG DELETE_FLAG, CURRENT_ROW_FLAG CURRENT_ROW_FLAG, ERROR_MESSAGE ERROR_MESSAGE, CUST_TRX_NUMBER CUST_TRX_NUMBER, CUST_TRX_ID CUST_TRX_ID, CUST_TRX_LINE_ID CUST_TRX_LINE_ID, COUNTRY_CODE COUNTRY_CODE, APPLICATION_REF_TYPE APPLICATION_REF_TYPE, APPLICATION_REF_ID APPLICATION_REF_ID, APPLICATION_REF_NUM APPLICATION_REF_NUM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, REQUESTED_BY REQUESTED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15 from "PON"."PON_EMD_TRANSACTIONS"

View Text - HTML Formatted

SELECT EMD_TRANSACTION_ID EMD_TRANSACTION_ID
, EMD_TRANSACTION_GROUP_ID EMD_TRANSACTION_GROUP_ID
, PARENT_EMD_TRANSACTION_ID PARENT_EMD_TRANSACTION_ID
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, SUPPLIER_SEQUENCE SUPPLIER_SEQUENCE
, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, AMOUNT AMOUNT
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_DATE EXCHANGE_DATE
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, CASH_BEARER_NAME CASH_BEARER_NAME
, BANK_NAME BANK_NAME
, BANK_BRANCH_NAME BANK_BRANCH_NAME
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_ACCOUNT_CURRENCY BANK_ACCOUNT_CURRENCY
, BANK_GURANTEE_NUMBER BANK_GURANTEE_NUMBER
, CREDIT_CARD_NUM CREDIT_CARD_NUM
, CARD_OWNER_ID CARD_OWNER_ID
, NAME_ON_CARD NAME_ON_CARD
, CARD_ISSUER_CODE CARD_ISSUER_CODE
, PURCHASE_CARD_FLAG PURCHASE_CARD_FLAG
, SINGLE_USE_FLAG SINGLE_USE_FLAG
, TYPE_OF_CARD TYPE_OF_CARD
, EXPIRY_DATE EXPIRY_DATE
, CHEQUE_NUMBER CHEQUE_NUMBER
, IN_FAVOR_OF IN_FAVOR_OF
, DEMAND_DRAFT_NUM DEMAND_DRAFT_NUM
, PAYABLE_AT PAYABLE_AT
, ORG_ID ORG_ID
, DOCUMENT_SUBMITTED DOCUMENT_SUBMITTED
, JUSTIFICATION JUSTIFICATION
, POSTED_TO_FINANCE POSTED_TO_FINANCE
, DELETE_FLAG DELETE_FLAG
, CURRENT_ROW_FLAG CURRENT_ROW_FLAG
, ERROR_MESSAGE ERROR_MESSAGE
, CUST_TRX_NUMBER CUST_TRX_NUMBER
, CUST_TRX_ID CUST_TRX_ID
, CUST_TRX_LINE_ID CUST_TRX_LINE_ID
, COUNTRY_CODE COUNTRY_CODE
, APPLICATION_REF_TYPE APPLICATION_REF_TYPE
, APPLICATION_REF_ID APPLICATION_REF_ID
, APPLICATION_REF_NUM APPLICATION_REF_NUM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, REQUESTED_BY REQUESTED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
FROM "PON"."PON_EMD_TRANSACTIONS"