[Home] [Help] [Dependency Information]
Object Name: | FV_TREAS_PMTS_TRANSACTION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View used as Transaction view for Treasury Accomplishment event class
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TREASURY_CONFIRMATION_ID | NUMBER | (15) | Yes | Treasury confirmation Id |
TREASURY_DOC_DATE | DATE | Yes | Treasury accomplishment date | |
PAYMENT_DOCUMENT_NAME | VARCHAR2 | (100) | Payment document name | |
PAYMENT_INSTRUCTION_REF_CODE | VARCHAR2 | (255) | Admin assigned reference code for payment instruction ID | |
PAYMENT_INSTRUCTION_ID | NUMBER | (15) | Yes | Payment instruction identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TREASURY_CONFIRMATION_ID
, TREASURY_DOC_DATE
, PAYMENT_DOCUMENT_NAME
, PAYMENT_INSTRUCTION_REF_CODE
, PAYMENT_INSTRUCTION_ID
FROM APPS.FV_TREAS_PMTS_TRANSACTION_V;
APPS.FV_TREAS_PMTS_TRANSACTION_V is not referenced by any database object
|
|
|