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

TABLE: JE.JE_NO_GEI_CONTROLAS

Object Details
Object Name: JE_NO_GEI_CONTROLAS
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_NO_GEI_CONTROLAS
Subobject Name:
Status: VALID


Table Stores info about ordering and recieving files related to A-Report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORDER_NUMBER NUMBER (35) Yes Order number
D_DATE DATE

The date for when the A-Report was ordered
COORDINATOR VARCHAR2 (35)
The person who can be referred to on matters concerning the order
PHONE VARCHAR2 (10)
Phone number
FAX VARCHAR2 (10)
Fax number
PERIOD_START VARCHAR2 (15)
Period start
PERIOD_END VARCHAR2 (15)
Period end
MSG_PERIOD_START VARCHAR2 (6)
Start period for the order
MSG_PERIOD_END VARCHAR2 (6)
End period for the order
MSG_RECEIPT_TYPE VARCHAR2 (2)
Type of receipt recieved from FIN
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORDER_NUMBER
,      D_DATE
,      COORDINATOR
,      PHONE
,      FAX
,      PERIOD_START
,      PERIOD_END
,      MSG_PERIOD_START
,      MSG_PERIOD_END
,      MSG_RECEIPT_TYPE
FROM JE.JE_NO_GEI_CONTROLAS;

Dependencies

[top of page]

JE.JE_NO_GEI_CONTROLAS does not reference any database object

JE.JE_NO_GEI_CONTROLAS is referenced by following:

SchemaJE
ViewJE_NO_GEI_CONTROLAS#