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]

VIEW: APPS.MSC_DRP_ITEM_ALLOCATIONS_V

Object Details

Object Name:	MSC_DRP_ITEM_ALLOCATIONS_V
Object Type:	VIEW
Owner:	APPS
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
PLAN_ID	NUMBER		Yes	Plan id
PLAN_ORGANIZATION_ID	NUMBER		Yes	Organization identifier of the organization owning the plan
PLAN_INSTANCE_ID	NUMBER		Yes	Source instance id for the org
INVENTORY_ITEM_ID	NUMBER		Yes	Item id
ITEM_SEGMENTS	VARCHAR2	(250)	Yes	Item name
ORGANIZATION_ID	NUMBER		Yes	Source org id
SR_INSTANCE_ID	NUMBER		Yes	Source org's instance id
ORGANIZATION_CODE	VARCHAR2	(4000)		Organization Code
DEST_ORGANIZATION_ID	NUMBER		Yes	Destination Organization ID
DEST_SR_INSTANCE_ID	NUMBER		Yes	Destination Organization's Source Instance Id
DEST_ORGANIZATION_CODE	VARCHAR2	(4000)		To Organization Code
EFFECTIVE_DATE	DATE		Yes	From Date
DISABLE_DATE	DATE			To Date
ALLOC_PERCENT	NUMBER			Allocation Percentage
RANK	NUMBER			Rank
ALLOC_RULE_ID	NUMBER		Yes	Allocation Rule ID
ALLOC_RULE_NAME	VARCHAR2	(30)		Rule Name
ALLOC_RULE_DESC	VARCHAR2	(80)		Description
ALLOC_RULE_TYPE	NUMBER			Rule Type number
ALLOC_RULE_TYPE_TEXT	VARCHAR2	(4000)		Rule Type
ASSIGNMENT_ID	NUMBER			Assignment ID
ASSIGNMENT_SET_ID	NUMBER			Assignment Set id
ASSIGNMENT_TYPE	NUMBER			Assignment Type - number
ASSIGNMENT_TYPE_TEXT	VARCHAR2	(4000)		Assignment Type TExt
DMD_PRI_OVERRIDE	NUMBER			Demand Priority Override
DMD_PRI_OVERRIDE_TEXT	VARCHAR2	(4000)		Demand Priority Override Text
DMD_PRIORITY	NUMBER			Demand Priority
FIXED_LOT_MULTIPLIER	NUMBER			Fixed Lot Multiplier
CATEGORY_SET_ID	NUMBER		Yes	Category Set Id
CATEGORY_ID	NUMBER		Yes	Category Id
LAST_UPDATED_BY	NUMBER		Yes	Who Column
LAST_UPDATE_DATE	DATE		Yes	Who Column
CREATED_BY	NUMBER		Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER			Who Column
MIN_ORDER_QTY	NUMBER
MAX_ORDER_QTY	NUMBER

Query Text

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


SELECT PLAN_ID
,      PLAN_ORGANIZATION_ID
,      PLAN_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      DEST_ORGANIZATION_ID
,      DEST_SR_INSTANCE_ID
,      DEST_ORGANIZATION_CODE
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      ALLOC_PERCENT
,      RANK
,      ALLOC_RULE_ID
,      ALLOC_RULE_NAME
,      ALLOC_RULE_DESC
,      ALLOC_RULE_TYPE
,      ALLOC_RULE_TYPE_TEXT
,      ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_TYPE_TEXT
,      DMD_PRI_OVERRIDE
,      DMD_PRI_OVERRIDE_TEXT
,      DMD_PRIORITY
,      FIXED_LOT_MULTIPLIER
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      MIN_ORDER_QTY
,      MAX_ORDER_QTY
FROM APPS.MSC_DRP_ITEM_ALLOCATIONS_V;

Dependencies

[top of page]

APPS.MSC_DRP_ITEM_ALLOCATIONS_V references the following:

APPS: MSC_DRP_ALLOC_RULES; MSC_DRP_ITEM_ALLOCATIONS; MSC_GET_NAME - show dependent code; MSC_ITEMS; MSC_ITEM_CATEGORIES; MSC_PLANS; MSC_SR_ASSIGNMENTS

APPS.MSC_DRP_ITEM_ALLOCATIONS_V is not referenced by any database object