[Home] [Help] [Dependency Information]
Object Name: | MTL_TRANSACTION_FLOW_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_TRANSACTION_FLOW_HEADERS |
Subobject Name: | |
Status: | VALID |
MTL_TRANSACTION_FLOW_HEADERS is used to store the start OU and the end OU of the inter-company transaction flow for Drop Ship or Global Procurement.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_TRANSACTION_FLOW_HEADER_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
START_ORG_ID
END_ORG_ID FLOW_TYPE QUALIFIER_CODE QUALIFIER_VALUE_ID START_DATE END_DATE ORGANIZATION_ID |
MTL_TRANSACTION_FLOW_HEADER_U2 | NORMAL | NONUNIQUE | APPS_TS_SEED | HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Header Identifier for the Inter-Company transaction flow. | |
START_ORG_ID | NUMBER | Yes | Start Organization Identifier - This is the Start Operating Unit for a transaction flow. | |
END_ORG_ID | NUMBER | Yes | End Operating Unit for a Inter-Company Transaction Flow. | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | User who last updated the record. | |
CREATION_DATE | DATE | Yes | The date when the record is created. | |
CREATED_BY | NUMBER | Yes | User who created the record. | |
LAST_UPDATE_LOGIN | NUMBER | User who last login | ||
FLOW_TYPE | NUMBER | Yes | The Inter-company Flow Type. The possible value for this column are: 1 - Shipping Flow2 - Procuring Flow. | |
ORGANIZATION_ID | NUMBER | The default organization for the transactio flow. For shipping flow, this is the ship from inventory organization. For procuring flow, this is the ship to inventory organization. | ||
QUALIFIER_CODE | NUMBER | The qualifier code for inter-company transaction flow. This is a lookup code in mfg lookups with lookup type = 'INV_TRANSACTION_FLOW_QUALIFIER' | ||
QUALIFIER_VALUE_ID | NUMBER | The qualifier value for a particular qualifer. For 115.10 release, the value is the item category identifier. | ||
START_DATE | DATE | Yes | The start date when a Inter-company transaction flow is active. | |
END_DATE | DATE | The End Date when an Inter-Company transaction flow is active. | ||
ASSET_ITEM_PRICING_OPTION | NUMBER | The Pricing option for asset item. This column is enable for procuring flow. The possible value is 1 - PO Price, 2 - Transfer Price. | ||
EXPENSE_ITEM_PRICING_OPTION | NUMBER | The pricing option for expense item for procuring flow.The possible value is 1 - PO Price, 2 - Transfer Price. | ||
NEW_ACCOUNTING_FLAG | VARCHAR2 | (1) | Yes | The new accounting flag - a flag to indicate whether old accounting will be use or new accounting will be use. If 'Y' then new accounting is used, otherwise, old accounting is used. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute Category - The Descriptive Flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, START_ORG_ID
, END_ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FLOW_TYPE
, ORGANIZATION_ID
, QUALIFIER_CODE
, QUALIFIER_VALUE_ID
, START_DATE
, END_DATE
, ASSET_ITEM_PRICING_OPTION
, EXPENSE_ITEM_PRICING_OPTION
, NEW_ACCOUNTING_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM INV.MTL_TRANSACTION_FLOW_HEADERS;
INV.MTL_TRANSACTION_FLOW_HEADERS does not reference any database object
INV.MTL_TRANSACTION_FLOW_HEADERS is referenced by following:
|
|
|