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

VIEW: GML.OP_PRSL_AUD#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHANGEPRSL_LINE_ID NUMBER (10) Yes
PRICEREAS_CODE VARCHAR2 (4) Yes
CHANGEPRSL_ID NUMBER (10) Yes
NET_PRICE NUMBER
Yes
CHANGE_COMMENT VARCHAR2 (70) Yes
ORDER_QTY1 NUMBER
Yes
BSO_MINTOTALQTY1 NUMBER
Yes
BSO_MAXTOTALQTY1 NUMBER
Yes
BSO_MINTOTALVALUE NUMBER
Yes
BSO_MAXTOTALVALUE NUMBER
Yes
ORDER_UM1 VARCHAR2 (4) Yes
AVAILABILITY_LEADTIME NUMBER
Yes
TRANSIT_LEADTIME NUMBER
Yes
QC_GRADE_WANTED VARCHAR2 (4) Yes
SHIPPER_CODE VARCHAR2 (4) Yes
SHIPCUST_ID NUMBER (10) Yes
SHIPADDR_ID NUMBER (10) Yes
TO_WHSE VARCHAR2 (4) Yes
FROM_WHSE VARCHAR2 (4) Yes
PRESALES_ORDLINE_ID NUMBER (10) Yes
STATUS_IND NUMBER (5) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
DELETE_MARK NUMBER (5) Yes
Query Text

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


SELECT CHANGEPRSL_LINE_ID
,      PRICEREAS_CODE
,      CHANGEPRSL_ID
,      NET_PRICE
,      CHANGE_COMMENT
,      ORDER_QTY1
,      BSO_MINTOTALQTY1
,      BSO_MAXTOTALQTY1
,      BSO_MINTOTALVALUE
,      BSO_MAXTOTALVALUE
,      ORDER_UM1
,      AVAILABILITY_LEADTIME
,      TRANSIT_LEADTIME
,      QC_GRADE_WANTED
,      SHIPPER_CODE
,      SHIPCUST_ID
,      SHIPADDR_ID
,      TO_WHSE
,      FROM_WHSE
,      PRESALES_ORDLINE_ID
,      STATUS_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
FROM GML.OP_PRSL_AUD#;

Dependencies

[top of page]

GML.OP_PRSL_AUD# references the following:

SchemaGML
TableOP_PRSL_AUD
GML.OP_PRSL_AUD# is referenced by following:

SchemaAPPS
SynonymOP_PRSL_AUD