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


TABLE: OE.JE_IT_PACKSLIPS

Object Details
Object Name: JE_IT_PACKSLIPS
Object Type: TABLE
Owner: OE
FND Design Data: TableJE.JE_IT_PACKSLIPS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_IT_PACKSLIPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPICKING_HEADER_ID
JE_IT_PACKSLIPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPACKSLIP_NUMBER
Columns
Name Datatype Length Mandatory Comments
PACKSLIP_NUMBER NUMBER
Yes
PACKSLIP_DATE DATE
Yes
PICKING_HEADER_ID NUMBER
Yes
Query Text

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


SELECT PACKSLIP_NUMBER
,      PACKSLIP_DATE
,      PICKING_HEADER_ID
FROM OE.JE_IT_PACKSLIPS;

Dependencies

[top of page]

OE.JE_IT_PACKSLIPS does not reference any database object

OE.JE_IT_PACKSLIPS is referenced by following:

SchemaAPPS
SynonymJE_IT_PACKSLIPS