[Home] [Help] [Dependency Information]
Object Name: | FV_STATUS_OBLIG_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_STATUS_OBLIG_TEMP |
Subobject Name: | |
Status: | VALID |
FV_STATUS_OBLIG_TEMP is a temporary report table for the Status of Obligation report.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_STATUS_OBLIG_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PO_DISTRIBUTION_ID |
FV_STATUS_OBLIG_TEMP_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INV_PO_DISTRIBUTION_ID |
FV_STATUS_OBLIG_TEMP_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PO_REQ_DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQNUM | VARCHAR2 | (20) | Requisition number | |
REQDATE | DATE | Requisition date | ||
REQAMT | NUMBER | Requisition amount | ||
REQCCID | NUMBER | Request code combination identifier | ||
OBLIGNUM | VARCHAR2 | (20) | Obligation number | |
OBLIGDATE | DATE | Obligation date | ||
OBLIGAMT | NUMBER | Obligation amount | ||
OBLIGCCID | NUMBER | Obligation code combination identifier | ||
OBLIGSTATUS | VARCHAR2 | (25) | Obligation status | |
INVNUM | VARCHAR2 | (50) | Invoice number | |
INVDATE | DATE | Invoice date | ||
INVAMT | NUMBER | Invoice amount | ||
INVCCID | NUMBER | Invoice code combination identifier | ||
SEGVAL1 | VARCHAR2 | (60) | Segment 1 value | |
SEGVAL2 | VARCHAR2 | (60) | Segment 2 value | |
SEGVAL3 | VARCHAR2 | (60) | Segment 3 value | |
INV_PO_DISTRIBUTION_ID | NUMBER | Invoice distribution identifier | ||
PO_REQ_DISTRIBUTION_ID | NUMBER | Requisition distribution identifier | ||
PO_DISTRIBUTION_ID | NUMBER | Purchase distribution identifier |
Cut, paste (and edit) the following text to query this object:
SELECT REQNUM
, REQDATE
, REQAMT
, REQCCID
, OBLIGNUM
, OBLIGDATE
, OBLIGAMT
, OBLIGCCID
, OBLIGSTATUS
, INVNUM
, INVDATE
, INVAMT
, INVCCID
, SEGVAL1
, SEGVAL2
, SEGVAL3
, INV_PO_DISTRIBUTION_ID
, PO_REQ_DISTRIBUTION_ID
, PO_DISTRIBUTION_ID
FROM FV.FV_STATUS_OBLIG_TEMP;
FV.FV_STATUS_OBLIG_TEMP does not reference any database object
FV.FV_STATUS_OBLIG_TEMP is referenced by following:
|
|
|