eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GML.OP_ORDR_TYP_B

Object Details

Object Name:	OP_ORDR_TYP_B
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_ORDR_TYP_B
Subobject Name:
Status:	VALID

User-defined order types and descriptions are maintained in this table. Order types control the processing of a sales order. One order type, SO (ORDER_TYPE = 1), is predefined for new and existing OPM sales orders entered prior to Release 4.10.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_TYP_B_PK	NORMAL	UNIQUE	APPS_TS_SEED	ORDER_TYPE
OP_ORDR_TYP_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORDER_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_TYPE	NUMBER	(5)	Yes	Unique identifier of user-defined order type; assigned by system. Order types 0 and 1 are reserved; 0 is not a valid order_type and 1 is a seeded order type for new and existing sales orders. Any additional order types will start with "2".
LANG_CODE	VARCHAR2	(4)		Obsolete column - no longer used.
ORDER_TYPE_CODE	VARCHAR2	(8)	Yes	User-defined code to distinguish order type; appears whenever order type is displayed and is entered by user on order.
INVEN_TRANS_TYPE	NUMBER	(5)	Yes	Inventory transaction type. Valid values are: 0 means normal sales order inventory transaction; 1 means consignment inventory transaction created; 2 means interplant inventory transaction created
SHIPMENT_IND	NUMBER	(5)	Yes	Indicates if order produces a shipment. Valid values are: 0 means a shipment is not created from the order; 1 means a shipment must be created from the order
INVOICE_IND	NUMBER	(5)	Yes	Indicates if order produces an invoice. Valid values are: 0 means no invoice is created for this order; 1 means that an invoice must be created for this order; 2 is for future use with automatic invoice creation
PICKINGLST_IND	NUMBER	(5)	Yes	Indicates if a picking list can be created for the order. Valid values are: 0 - no picking list is produced; 1 - that a picklist can be produced; 2 - for future use with automatic creation of a picklist
EXPORTDOC_IND	NUMBER	(5)	Yes	Indicates if export documentation must be created. Valid values are: 0 - no export documentation is produced; 1 - a proforma invoice can be created; 2 - for future use with external export doc software
TOTALORD_IND	NUMBER	(5)	Yes	Total order pricing switch. 0 (default) = line by line pricing. 1 = total order pricing.
UPDATE_SALESHIST	NUMBER	(5)	Yes	Update sales history table - not currently supported or used.
CREDITCHK_TYPE	NUMBER	(5)	Yes	Indicates if credit checking should be performed for this order. Valid values are: 0 - no credit checking performed; 1 - credit checking performed according to the system variable which indicates if Oracle AR is installed/used.
PRICE_ORDER	NUMBER	(5)	Yes	Indicates if order should be priced. Valid values are: 0 - order is not priced (prices will default to zero); 1 - the order is priced using prices established in the pricing tables.
CALC_COMM_IND	NUMBER	(5)	Yes	Indicates if commission should be calculated for the order. For future use.
CALC_TAX_IND	NUMBER	(5)	Yes	Indicates if taxes should be calculated for this order. Valid values are: 0 - taxes are not calculated; 1 - taxes are calculated.
PRODORDR_IND	NUMBER	(5)	Yes	Indicates that a production order is created for the sales order. This flag is for future use.
SHIPTO_REQUIRED	NUMBER	(5)	Yes	Indicates if the ship-to customer record must exist to enter this order type. For future use.
UPDATE_AUDITTRAIL	NUMBER	(5)	Yes	Indicates if this order type updates the order audit trail when changes are made to the order. Valid values: 0 - the order does not update the audit trail; 1 - the audit trail is updated when changes are made on the order lines.
ORDER_LEADTIME	NUMBER	(5)	Yes	Number of days required to process an order. This is an administrative leadtime used to compute a scheduled ship date
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	0 means that record is active; 1 means that record has been "deleted".

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 does not reference any database object

GML.OP_ORDR_TYP_B is referenced by following:

APPS: OP_ORDR_TYP_B