[Home] [Help]
[Dependency Information]
| Object Name: | IGS_FI_UNPOSTED_TRANSACTIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGS.IGS_FI_UNPOSTED_TRANSACTIONS
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GL_DATE | DATE | The General Ledger Date. | ||
| ACCOUNT_CODE | VARCHAR2 | (40) | The Account Code. | |
| GL_CCID | NUMBER | The Accounting Key Flexfield. | ||
| AMOUNT | NUMBER | The Amount of the un-posted transaction. | ||
| TRX_TYPE | CHAR | (2) | The Transaction Type (Debit or Credit). |
Cut, paste (and edit) the following text to query this object:
SELECT GL_DATE
, ACCOUNT_CODE
, GL_CCID
, AMOUNT
, TRX_TYPE
FROM APPS.IGS_FI_UNPOSTED_TRANSACTIONS;
APPS
IGS_AD_APP_REQ
IGS_FI_APPLICATIONS
IGS_FI_CR_ACTIVITIES
IGS_FI_GEN_005
- show dependent code
IGS_FI_INVLN_INT
APPS.IGS_FI_UNPOSTED_TRANSACTIONS is not referenced by any database object
|
|
|
|