eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: FV.FV_STATUS_OBLIG_TEMP#

Object Details

Object Name:	FV_STATUS_OBLIG_TEMP#
Object Type:	VIEW
Owner:	FV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
REQNUM	VARCHAR2	(20)
REQDATE	DATE
REQAMT	NUMBER
REQCCID	NUMBER
OBLIGNUM	VARCHAR2	(20)
OBLIGDATE	DATE
OBLIGAMT	NUMBER
OBLIGCCID	NUMBER
OBLIGSTATUS	VARCHAR2	(25)
INVNUM	VARCHAR2	(50)
INVDATE	DATE
INVAMT	NUMBER
INVCCID	NUMBER
SEGVAL1	VARCHAR2	(60)
SEGVAL2	VARCHAR2	(60)
SEGVAL3	VARCHAR2	(60)
INV_PO_DISTRIBUTION_ID	NUMBER
PO_REQ_DISTRIBUTION_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER

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# references the following:

FV: FV_STATUS_OBLIG_TEMP

FV.FV_STATUS_OBLIG_TEMP# is referenced by following:

APPS: FV_STATUS_OBLIG_TEMP