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

VIEW: GML.OP_RELS_SCH#

Object Details
Object Name: OP_RELS_SCH#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RELEASELINE_ID NUMBER (10) Yes
CONTRACT_ID NUMBER (10) Yes
SCHED_SHIPDATE DATE
Yes
RELEASE_STATUS NUMBER (5) Yes
REQD_DLVDATE DATE
Yes
ORDER_QTY1 NUMBER
Yes
ORDER_QTY2 NUMBER

ORDER_UM1 VARCHAR2 (4) Yes
ORDER_UM2 VARCHAR2 (4)
EXPECTED_NET_PRICE NUMBER
Yes
FROM_WHSE VARCHAR2 (4) Yes
TO_WHSE VARCHAR2 (4)
SHIPADDR_ID NUMBER (10) Yes
SHIP_MTHD VARCHAR2 (4) Yes
SHIPPER_CODE VARCHAR2 (4) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
TRANS_CNT NUMBER (10)
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
RELEASE_VALUE NUMBER
Yes
RELEASE_NO NUMBER (5) Yes
PRESALES_ORDLINE_ID NUMBER (10) Yes
Query Text

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


SELECT RELEASELINE_ID
,      CONTRACT_ID
,      SCHED_SHIPDATE
,      RELEASE_STATUS
,      REQD_DLVDATE
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      EXPECTED_NET_PRICE
,      FROM_WHSE
,      TO_WHSE
,      SHIPADDR_ID
,      SHIP_MTHD
,      SHIPPER_CODE
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      RELEASE_VALUE
,      RELEASE_NO
,      PRESALES_ORDLINE_ID
FROM GML.OP_RELS_SCH#;

Dependencies

[top of page]

GML.OP_RELS_SCH# references the following:

SchemaGML
TableOP_RELS_SCH
GML.OP_RELS_SCH# is referenced by following:

SchemaAPPS
SynonymOP_RELS_SCH