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


VIEW: APPS.MTL_ORG_ASSIGN_V

Object Details
Object Name: MTL_ORG_ASSIGN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ORG_ASSIGN_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER


ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240)

INVENTORY_ITEM_ID NUMBER


PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
PRIMARY_UNIT_OF_MEASURE_TL VARCHAR2 (25)
SALES_ACCOUNT NUMBER


COST_OF_SALES_ACCOUNT NUMBER


EXPENSE_ACCOUNT NUMBER


ENCUMBRANCE_ACCOUNT NUMBER


ASSIGNED_FLAG CHAR (1)

MASTER_ORGANIZATION_ID NUMBER

EAM_ENABLED_FLAG VARCHAR2 (1)
SECONDARY_UOM_CODE VARCHAR2 (3)

TRACKING_QUANTITY_IND VARCHAR2 (30)

SECONDARY_DEFAULT_IND VARCHAR2 (30)

ONT_PRICING_QTY_SOURCE VARCHAR2 (30)

DUAL_UOM_DEVIATION_HIGH NUMBER


DUAL_UOM_DEVIATION_LOW NUMBER


Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      INVENTORY_ITEM_ID
,      PRIMARY_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE_TL
,      SALES_ACCOUNT
,      COST_OF_SALES_ACCOUNT
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      ASSIGNED_FLAG
,      MASTER_ORGANIZATION_ID
,      EAM_ENABLED_FLAG
,      SECONDARY_UOM_CODE
,      TRACKING_QUANTITY_IND
,      SECONDARY_DEFAULT_IND
,      ONT_PRICING_QTY_SOURCE
,      DUAL_UOM_DEVIATION_HIGH
,      DUAL_UOM_DEVIATION_LOW
FROM APPS.MTL_ORG_ASSIGN_V;

Dependencies

[top of page]

APPS.MTL_ORG_ASSIGN_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageINVIDIT3 - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_B
SynonymMTL_UNITS_OF_MEASURE_TL

APPS.MTL_ORG_ASSIGN_V is not referenced by any database object