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

TABLE: INV.MTL_INTERORG_PARAMETERS

Object Details
Object Name: MTL_INTERORG_PARAMETERS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_INTERORG_PARAMETERS
Subobject Name:
Status: VALID


MTL_INTERORG_PARAMETERS identifies the receiving organizations ("To"
distribution organizations) linked to a particular organization
("From" distribution organizations). The TO_ORGANIZATION_ID
identifies the organization that receives shipments from the
organization identified by the FROM_ORGANIZATION_ID.
.
You must define the inter-organizational relationship here before you
perform any inter-organization transfers in the transaction system.
.
INTRANSIT_TYPE indicates whether inter-organizational transfers
between the two organizations will use direct or intransit transfer.
.
FOB_POINT indicates the 'Free on board' point and determines
the point of transfer of liability/ownership.
.
Unit of measure, distance, transfer charge, and accounting information
are also specified in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_INTERORG_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTO_ORGANIZATION_ID
ColumnFROM_ORGANIZATION_ID
MTL_INTERORG_PARAMETERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFROM_ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
FROM_ORGANIZATION_ID NUMBER
Yes "From" organization identifier
TO_ORGANIZATION_ID NUMBER
Yes "To" organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
INTRANSIT_TYPE NUMBER

Indicates whether to use direct or intransit transfer
DISTANCE_UOM_CODE VARCHAR2 (3)
Distance unit of measure code
TO_ORGANIZATION_DISTANCE NUMBER

"To" organization code distance
FOB_POINT NUMBER

Free on board point
MATL_INTERORG_TRANSFER_CODE NUMBER

Inter-organization transfer charge type
ROUTING_HEADER_ID NUMBER

Default receipt routing
INTERNAL_ORDER_REQUIRED_FLAG NUMBER

Flag indicating an internal order is required
INTRANSIT_INV_ACCOUNT NUMBER

Inter-organization transfer debit account
INTERORG_TRNSFR_CHARGE_PERCENT NUMBER

Inter-organization transfer charge percent
INTERORG_TRANSFER_CR_ACCOUNT NUMBER

Inter-organization transfer credit account
INTERORG_RECEIVABLES_ACCOUNT NUMBER

Inter-organization receivables account
INTERORG_PAYABLES_ACCOUNT NUMBER

Inter-organization payables account
INTERORG_PRICE_VAR_ACCOUNT NUMBER

Inter-organization price variance account
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
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
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (1)
Global descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global descriptive flexfield segment
ELEMENTAL_VISIBILITY_ENABLED VARCHAR2 (1)
Elemental Visibility Enabled
MANUAL_RECEIPT_EXPENSE VARCHAR2 (1)
Manual receipt required for expense destination
PROFIT_IN_INV_ACCOUNT NUMBER

Inter-organization profit in inventory account
SHIKYU_ENABLED_FLAG VARCHAR2 (1)
Obsolete
SHIKYU_DEFAULT_ORDER_TYPE_ID NUMBER

SHIKYU Default Order Type Identifier
SHIKYU_OEM_VAR_ACCOUNT_ID NUMBER

SHIKYU Variance Account Identifier of the From Organization
SHIKYU_TP_OFFSET_ACCOUNT_ID NUMBER

SHIKYU Offset Account Identifier of the To Organization.
INTERORG_PROFIT_ACCOUNT NUMBER

Interorg Profit Account
PRICELIST_ID NUMBER

Price List Identifier
SUBCONTRACTING_TYPE VARCHAR2 (1)
Subcontracting type between the OEM and the MP. Possible values are null, B for Buy/Sell and C for Chargeable Subcontracting.
Query Text

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


SELECT FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INTRANSIT_TYPE
,      DISTANCE_UOM_CODE
,      TO_ORGANIZATION_DISTANCE
,      FOB_POINT
,      MATL_INTERORG_TRANSFER_CODE
,      ROUTING_HEADER_ID
,      INTERNAL_ORDER_REQUIRED_FLAG
,      INTRANSIT_INV_ACCOUNT
,      INTERORG_TRNSFR_CHARGE_PERCENT
,      INTERORG_TRANSFER_CR_ACCOUNT
,      INTERORG_RECEIVABLES_ACCOUNT
,      INTERORG_PAYABLES_ACCOUNT
,      INTERORG_PRICE_VAR_ACCOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ELEMENTAL_VISIBILITY_ENABLED
,      MANUAL_RECEIPT_EXPENSE
,      PROFIT_IN_INV_ACCOUNT
,      SHIKYU_ENABLED_FLAG
,      SHIKYU_DEFAULT_ORDER_TYPE_ID
,      SHIKYU_OEM_VAR_ACCOUNT_ID
,      SHIKYU_TP_OFFSET_ACCOUNT_ID
,      INTERORG_PROFIT_ACCOUNT
,      PRICELIST_ID
,      SUBCONTRACTING_TYPE
FROM INV.MTL_INTERORG_PARAMETERS;

Dependencies

[top of page]

INV.MTL_INTERORG_PARAMETERS does not reference any database object

INV.MTL_INTERORG_PARAMETERS is referenced by following:

SchemaAPPS
SynonymMTL_INTERORG_PARAMETERS