DBA Data[Home] [Help] [Dependency Information]

TABLE: PON.PON_EMD_TRANSACTIONS

Object Details
Object Name: PON_EMD_TRANSACTIONS
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_EMD_TRANSACTIONS
Subobject Name:
Status: VALID


This table stores all EMD transactions done at negotiation level


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EMD_TRANSACTION_ID NUMBER (15) Yes EMD transaction id
EMD_TRANSACTION_GROUP_ID NUMBER (15)
EMD transaction group id
PARENT_EMD_TRANSACTION_ID NUMBER (15)
EMD transaction id against which refund/forfeit is performed
AUCTION_HEADER_ID NUMBER (15) Yes Auction header id of the negotiation
DOCUMENT_NUMBER VARCHAR2 (240)
Document number of the negotiation
SUPPLIER_SEQUENCE NUMBER
Yes Sequence of the supplier in pon_bidding_parties table
TRANSACTION_TYPE_CODE VARCHAR2 (30) Yes Transaction type code
STATUS_LOOKUP_CODE VARCHAR2 (30)
Status lookup code for the transaction
TRANSACTION_DATE DATE

Transaction date
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
AMOUNT NUMBER

Transaction amount
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for transaction
EXCHANGE_RATE NUMBER

Exchange rate for transaction
EXCHANGE_DATE DATE

Exchange date for transaction
PAYMENT_TYPE_CODE VARCHAR2 (30)
Payment type code
CASH_BEARER_NAME VARCHAR2 (360)
Cash bearer name
BANK_NAME VARCHAR2 (360)
Bank name for deposit transaction
BANK_BRANCH_NAME VARCHAR2 (360)
Bank branch name for deposit transaction
BANK_ACCOUNT_NUM VARCHAR2 (100)
Bank account number for deposit transaction
BANK_ACCOUNT_CURRENCY VARCHAR2 (15)
Bank account currency for deposit transaction
BANK_GURANTEE_NUMBER VARCHAR2 (50)
Bank guarantee for deposit transaction
CREDIT_CARD_NUM VARCHAR2 (30)
Credit card number
CARD_OWNER_ID NUMBER (15)
Card owner id
NAME_ON_CARD VARCHAR2 (80)
Name on credit card
CARD_ISSUER_CODE VARCHAR2 (30)
Card issuer code
PURCHASE_CARD_FLAG VARCHAR2 (1)
Indicates whether purchase card is used in the transaction
SINGLE_USE_FLAG VARCHAR2 (1)
Single use flag
TYPE_OF_CARD VARCHAR2 (30)
Type of card
EXPIRY_DATE DATE

Expiry date for credit card
CHEQUE_NUMBER VARCHAR2 (100)
Cheque number
IN_FAVOR_OF VARCHAR2 (150)
In favor of for Demand draft
DEMAND_DRAFT_NUM VARCHAR2 (100)
Demand draft number
PAYABLE_AT VARCHAR2 (360)
Demand draft payable at
ORG_ID NUMBER

Operating unit id
DOCUMENT_SUBMITTED VARCHAR2 (1)
Indicates if related documents are submitted in case of bank guarantee
JUSTIFICATION VARCHAR2 (2000)
Justification for refund/forfeit
POSTED_TO_FINANCE VARCHAR2 (1)
Indicates whether posted to finance
DELETE_FLAG VARCHAR2 (1)
Delete flag
CURRENT_ROW_FLAG VARCHAR2 (1)
Current row flag
ERROR_MESSAGE VARCHAR2 (4000)
Error message
CUST_TRX_NUMBER VARCHAR2 (20)
Customer transaction number
CUST_TRX_ID NUMBER (15)
Customer transaction id
CUST_TRX_LINE_ID NUMBER (15)
Customer transaction line id
COUNTRY_CODE VARCHAR2 (2)
Country code
APPLICATION_REF_TYPE VARCHAR2 (30)
Application reference type
APPLICATION_REF_ID NUMBER

Application reference id
APPLICATION_REF_NUM VARCHAR2 (30)
Application reference number
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
PROGRAM_APPLICATION_ID NUMBER

Identifier of owning application of concurrent program that last updated this row
PROGRAM_ID NUMBER

Identifier of the concurrent program that last updated this row
PROGRAM_UPDATE_DATE DATE

Date when this row was last updated by a concurrent program
REQUEST_ID NUMBER

Identifier of the concurrent program that last processed this row
REQUESTED_BY NUMBER (15)
Identifier of requester
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE_CATEGORY
ATTRIBUTE1 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE2 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE3 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE4 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE5 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE6 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE7 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE8 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE9 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE10 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE11 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE12 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE13 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE14 VARCHAR2 (150)
Extra Attribute Column
ATTRIBUTE15 VARCHAR2 (150)
Extra Attribute Column
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PON.PON_EMD_TRANSACTIONS does not reference any database object

PON.PON_EMD_TRANSACTIONS is referenced by following:

SchemaPON
ViewPON_EMD_TRANSACTIONS#