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

VIEW: GML.OP_ORDR_TYP_B#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_TYPE NUMBER (5) Yes
LANG_CODE VARCHAR2 (4)
ORDER_TYPE_CODE VARCHAR2 (8) Yes
INVEN_TRANS_TYPE NUMBER (5) Yes
SHIPMENT_IND NUMBER (5) Yes
INVOICE_IND NUMBER (5) Yes
PICKINGLST_IND NUMBER (5) Yes
EXPORTDOC_IND NUMBER (5) Yes
TOTALORD_IND NUMBER (5) Yes
UPDATE_SALESHIST NUMBER (5) Yes
CREDITCHK_TYPE NUMBER (5) Yes
PRICE_ORDER NUMBER (5) Yes
CALC_COMM_IND NUMBER (5) Yes
CALC_TAX_IND NUMBER (5) Yes
PRODORDR_IND NUMBER (5) Yes
SHIPTO_REQUIRED NUMBER (5) Yes
UPDATE_AUDITTRAIL NUMBER (5) Yes
ORDER_LEADTIME NUMBER (5) 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)
TEXT_CODE NUMBER (10)
DELETE_MARK NUMBER (5) Yes
Query Text

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


SELECT ORDER_TYPE
,      LANG_CODE
,      ORDER_TYPE_CODE
,      INVEN_TRANS_TYPE
,      SHIPMENT_IND
,      INVOICE_IND
,      PICKINGLST_IND
,      EXPORTDOC_IND
,      TOTALORD_IND
,      UPDATE_SALESHIST
,      CREDITCHK_TYPE
,      PRICE_ORDER
,      CALC_COMM_IND
,      CALC_TAX_IND
,      PRODORDR_IND
,      SHIPTO_REQUIRED
,      UPDATE_AUDITTRAIL
,      ORDER_LEADTIME
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.OP_ORDR_TYP_B#;

Dependencies

[top of page]

GML.OP_ORDR_TYP_B# references the following:

SchemaGML
TableOP_ORDR_TYP_B
GML.OP_ORDR_TYP_B# is referenced by following:

SchemaAPPS
SynonymOP_ORDR_TYP_B