[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_TRANSACTION_TYPES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_TRANSACTION_TYPES_ALL
|
| Subobject Name: | |
| Status: | VALID |
This table stores information about the order and line transaction types. This is a multi-org table.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_TRANSACTION_TYPES_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 TRANSACTION_TYPE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | Yes | This Column Stores Primary Key Value | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | Yes | This Column stores the value that distinguish order and line types |
| ORDER_CATEGORY_CODE | VARCHAR2 | (30) | This column indicates the type of lines (Regular/Return/Mixed) transaction type allows | |
| START_DATE_ACTIVE | DATE | Yes | This column stores the start date for transaction type | |
| END_DATE_ACTIVE | DATE | This column stores the end date for transaction type | ||
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program that last updated row. | ||
| PROGRAM_ID | NUMBER | Concurrent program that last updated row. | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| CURRENCY_CODE | VARCHAR2 | (30) | This column stores the GL currency code | |
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | This column stores GL coversion type | |
| CUST_TRX_TYPE_ID | NUMBER | Customer Transaction Type ID | ||
| COST_OF_GOODS_SOLD_ACCOUNT | NUMBER | This column stores GL account | ||
| ENTRY_CREDIT_CHECK_RULE_ID | NUMBER | This column stores Entry Credit Check Rule | ||
| SHIPPING_CREDIT_CHECK_RULE_ID | NUMBER | This column stores Credit check rule at shipping | ||
| PRICE_LIST_ID | NUMBER | Stores Price List | ||
| ENFORCE_LINE_PRICES_FLAG | VARCHAR2 | (1) | Stores flag to indicate enforce line price | |
| WAREHOUSE_ID | NUMBER | Stores warehouse | ||
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Stores customer demand class | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Stores Shipment Priority | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Stores shipping method | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Stores freight terms | |
| FOB_POINT_CODE | VARCHAR2 | (30) | Stores free on board point | |
| SHIP_SOURCE_TYPE_CODE | VARCHAR2 | (30) | Stores Shipment source type lookup | |
| AGREEMENT_TYPE_CODE | VARCHAR2 | (30) | Stores Agreement Type | |
| AGREEMENT_REQUIRED_FLAG | VARCHAR2 | (1) | Stores Agreement required flag | |
| PO_REQUIRED_FLAG | VARCHAR2 | (1) | Stores PO required flag | |
| INVOICING_RULE_ID | NUMBER | Invoicing rule used by AR for generating Invoice | ||
| INVOICING_CREDIT_METHOD_CODE | VARCHAR2 | (30) | Invoicing Credit method used by ar for returns | |
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule used by AR for generating Invoice | ||
| ACCOUNTING_CREDIT_METHOD_CODE | VARCHAR2 | (30) | Accounting Credit method used by ar for returns | |
| INVOICE_SOURCE_ID | NUMBER | Invoice Source for generating Invoice numbers | ||
| NON_DELIVERY_INVOICE_SOURCE_ID | NUMBER | Invoice Source for generating Invoice numbers for non delivery lines if invoice numbering method is 'DELIVERY' | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | This column is to tell whether the workflow associated with this return line type waits for inspection | |
| DEPOT_REPAIR_CODE | VARCHAR2 | (30) | Not Currently used. | |
| ORG_ID | NUMBER | Stores Operating Unit | ||
| AUTO_SCHEDULING_FLAG | VARCHAR2 | (1) | Stores Flag to drive scheduling operation | |
| SCHEDULING_LEVEL_CODE | VARCHAR2 | (30) | Stores Scheduling level | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| DEFAULT_INBOUND_LINE_TYPE_ID | NUMBER | This column stores default return line type for a return or a mixed order | ||
| DEFAULT_OUTBOUND_LINE_TYPE_ID | NUMBER | Stores default regular line type | ||
| TAX_CALCULATION_EVENT_CODE | VARCHAR2 | (30) | Is created from the oe_lookup code table for the column. | |
| PICKING_CREDIT_CHECK_RULE_ID | NUMBER | This column stores the credit check rule that is used during the picking phase | ||
| PACKING_CREDIT_CHECK_RULE_ID | NUMBER | This column stores the credit check rule that is used during the packing phase. | ||
| MIN_MARGIN_PERCENT | NUMBER | Minimum margin percentage allowed | ||
| SALES_DOCUMENT_TYPE_CODE | VARCHAR2 | (30) | For Future Release | |
| DEFAULT_LINE_SET_CODE | VARCHAR2 | (30) | Automatic addition of lines to Ship or Arraival Set can be defined at transaction type level using this column. | |
| DEFAULT_FULFILLMENT_SET | VARCHAR2 | (1) | Automatic addition of lines to fulfillment set can be defined at transaction type level using this column. | |
| DEF_TRANSACTION_PHASE_CODE | VARCHAR2 | (30) | Transaction phase that defaults to Sales document from transaction type. | |
| QUOTE_NUM_AS_ORD_NUM_FLAG | VARCHAR2 | (1) | To set Order Number same as Quote Number | |
| LAYOUT_TEMPLATE_ID | NUMBER | Stores the ID of the layout template that is associated with the transaction type. | ||
| CONTRACT_TEMPLATE_ID | NUMBER | Stores the ID of the contract template that is associated with the transaction type. | ||
| CREDIT_CARD_REV_REAUTH_CODE | VARCHAR2 | (30) | Stores the code to determine what should be the default behavior of Credit Card Reversal and Re-authorization functionality | |
| USE_AME_APPROVAL | VARCHAR2 | (1) | Tells whether to use AME approval process or not. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_TYPE_ID
, TRANSACTION_TYPE_CODE
, ORDER_CATEGORY_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, CURRENCY_CODE
, CONVERSION_TYPE_CODE
, CUST_TRX_TYPE_ID
, COST_OF_GOODS_SOLD_ACCOUNT
, ENTRY_CREDIT_CHECK_RULE_ID
, SHIPPING_CREDIT_CHECK_RULE_ID
, PRICE_LIST_ID
, ENFORCE_LINE_PRICES_FLAG
, WAREHOUSE_ID
, DEMAND_CLASS_CODE
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, FREIGHT_TERMS_CODE
, FOB_POINT_CODE
, SHIP_SOURCE_TYPE_CODE
, AGREEMENT_TYPE_CODE
, AGREEMENT_REQUIRED_FLAG
, PO_REQUIRED_FLAG
, INVOICING_RULE_ID
, INVOICING_CREDIT_METHOD_CODE
, ACCOUNTING_RULE_ID
, ACCOUNTING_CREDIT_METHOD_CODE
, INVOICE_SOURCE_ID
, NON_DELIVERY_INVOICE_SOURCE_ID
, INSPECTION_REQUIRED_FLAG
, DEPOT_REPAIR_CODE
, ORG_ID
, AUTO_SCHEDULING_FLAG
, SCHEDULING_LEVEL_CODE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DEFAULT_INBOUND_LINE_TYPE_ID
, DEFAULT_OUTBOUND_LINE_TYPE_ID
, TAX_CALCULATION_EVENT_CODE
, PICKING_CREDIT_CHECK_RULE_ID
, PACKING_CREDIT_CHECK_RULE_ID
, MIN_MARGIN_PERCENT
, SALES_DOCUMENT_TYPE_CODE
, DEFAULT_LINE_SET_CODE
, DEFAULT_FULFILLMENT_SET
, DEF_TRANSACTION_PHASE_CODE
, QUOTE_NUM_AS_ORD_NUM_FLAG
, LAYOUT_TEMPLATE_ID
, CONTRACT_TEMPLATE_ID
, CREDIT_CARD_REV_REAUTH_CODE
, USE_AME_APPROVAL
FROM ONT.OE_TRANSACTION_TYPES_ALL;
ONT.OE_TRANSACTION_TYPES_ALL does not reference any database object
ONT.OE_TRANSACTION_TYPES_ALL is referenced by following:
ONT
OE_TRANSACTION_TYPES_ALL#
|
|
|
|