[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_EMD_TRANSACTIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | PON |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EMD_TRANSACTION_ID | NUMBER | (15) | Yes | |
| EMD_TRANSACTION_GROUP_ID | NUMBER | (15) | ||
| PARENT_EMD_TRANSACTION_ID | NUMBER | (15) | ||
| AUCTION_HEADER_ID | NUMBER | (15) | Yes | |
| DOCUMENT_NUMBER | VARCHAR2 | (240) | ||
| SUPPLIER_SEQUENCE | NUMBER | Yes | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| STATUS_LOOKUP_CODE | VARCHAR2 | (30) | ||
| TRANSACTION_DATE | DATE | |||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | (15) | ||
| AMOUNT | NUMBER | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| EXCHANGE_RATE | NUMBER | |||
| EXCHANGE_DATE | DATE | |||
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | ||
| CASH_BEARER_NAME | VARCHAR2 | (360) | ||
| BANK_NAME | VARCHAR2 | (360) | ||
| BANK_BRANCH_NAME | VARCHAR2 | (360) | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | (100) | ||
| BANK_ACCOUNT_CURRENCY | VARCHAR2 | (15) | ||
| BANK_GURANTEE_NUMBER | VARCHAR2 | (50) | ||
| CREDIT_CARD_NUM | VARCHAR2 | (30) | ||
| CARD_OWNER_ID | NUMBER | (15) | ||
| NAME_ON_CARD | VARCHAR2 | (80) | ||
| CARD_ISSUER_CODE | VARCHAR2 | (30) | ||
| PURCHASE_CARD_FLAG | VARCHAR2 | (1) | ||
| SINGLE_USE_FLAG | VARCHAR2 | (1) | ||
| TYPE_OF_CARD | VARCHAR2 | (30) | ||
| EXPIRY_DATE | DATE | |||
| CHEQUE_NUMBER | VARCHAR2 | (100) | ||
| IN_FAVOR_OF | VARCHAR2 | (150) | ||
| DEMAND_DRAFT_NUM | VARCHAR2 | (100) | ||
| PAYABLE_AT | VARCHAR2 | (360) | ||
| ORG_ID | NUMBER | |||
| DOCUMENT_SUBMITTED | VARCHAR2 | (1) | ||
| JUSTIFICATION | VARCHAR2 | (2000) | ||
| POSTED_TO_FINANCE | VARCHAR2 | (1) | ||
| DELETE_FLAG | VARCHAR2 | (1) | ||
| CURRENT_ROW_FLAG | VARCHAR2 | (1) | ||
| ERROR_MESSAGE | VARCHAR2 | (4000) | ||
| CUST_TRX_NUMBER | VARCHAR2 | (20) | ||
| CUST_TRX_ID | NUMBER | (15) | ||
| CUST_TRX_LINE_ID | NUMBER | (15) | ||
| COUNTRY_CODE | VARCHAR2 | (2) | ||
| APPLICATION_REF_TYPE | VARCHAR2 | (30) | ||
| APPLICATION_REF_ID | NUMBER | |||
| APPLICATION_REF_NUM | VARCHAR2 | (30) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| REQUESTED_BY | NUMBER | (15) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) |
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#;
PON
PON_EMD_TRANSACTIONS
APPS
PON_EMD_TRANSACTIONS
|
|
|
|