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

TABLE: FV.FV_STATUS_OBLIG_TEMP

Object Details
Object Name: FV_STATUS_OBLIG_TEMP
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_STATUS_OBLIG_TEMP
Subobject Name:
Status: VALID


FV_STATUS_OBLIG_TEMP is a temporary report table for the Status of Obligation report.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_STATUS_OBLIG_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_DISTRIBUTION_ID
FV_STATUS_OBLIG_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINV_PO_DISTRIBUTION_ID
FV_STATUS_OBLIG_TEMP_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_REQ_DISTRIBUTION_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

FV.FV_STATUS_OBLIG_TEMP does not reference any database object

FV.FV_STATUS_OBLIG_TEMP is referenced by following:

SchemaAPPS
SynonymFV_STATUS_OBLIG_TEMP