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_MATERIAL_FLOW_DETAILS_V

Object Details

Object Name:	MSC_MATERIAL_FLOW_DETAILS_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
FROM_START_DATE	DATE
FROM_END_DATE	DATE
FROM_ORDER_NUMBER	VARCHAR2	(4000)
FROM_OPERATION_SEQ_ID	NUMBER
FROM_OPERATION_SEQUENCE	NUMBER
FROM_RESOURCE_SEQUENCE	NUMBER
FROM_DEPARTMENT	VARCHAR2	(4000)
FROM_RESOURCE_TRANS_ID	NUMBER
FROM_RESOURCE_ID	NUMBER
FROM_RESOURCE_CODE	VARCHAR2	(4000)
FROM_QUANTITY	NUMBER
MINIMUM_TRANSFER_QUANTITY	NUMBER
TO_START_DATE	DATE
TO_END_DATE	DATE
TO_ORDER_NUMBER	VARCHAR2	(4000)
TO_OPERATION_SEQ_ID	NUMBER
TO_OPERATION_SEQUENCE	NUMBER
TO_RESOURCE_SEQUENCE	NUMBER
TO_DEPARTMENT	VARCHAR2	(4000)
TO_RESOURCE_TRANS_ID	NUMBER
TO_RESOURCE_ID	NUMBER
TO_RESOURCE_CODE	VARCHAR2	(4000)
TO_QUANTITY	NUMBER
DEPENDENCY_TYPE	VARCHAR2	(4000)		This is the lookup value.(MSC_DEPENDENCY_TYPE).
DEPENDENCY_TYPE_ID	NUMBER			The dependency type number
MINIMUM_TIME_OFFSET	NUMBER
MAXIMUM_TIME_OFFSET	NUMBER
ACTUAL_TIME_OFFSET	NUMBER
PRODUCER_TRANS_ID	NUMBER		Yes
CONSUMER_TRANS_ID	NUMBER		Yes
PRODUCER_SR_INSTANCE_ID	NUMBER		Yes
CONSUMER_SR_INSTANCE_ID	NUMBER		Yes
PLAN_ID	NUMBER		Yes
FROM_ORG	VARCHAR2	(4000)
TO_ORG	VARCHAR2	(4000)
FROM_ITEM	VARCHAR2	(4000)
TO_ITEM	VARCHAR2	(4000)
FROM_ITEM_DESC	VARCHAR2	(4000)
TO_ITEM_DESC	VARCHAR2	(4000)

Query Text

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


SELECT FROM_START_DATE
,      FROM_END_DATE
,      FROM_ORDER_NUMBER
,      FROM_OPERATION_SEQ_ID
,      FROM_OPERATION_SEQUENCE
,      FROM_RESOURCE_SEQUENCE
,      FROM_DEPARTMENT
,      FROM_RESOURCE_TRANS_ID
,      FROM_RESOURCE_ID
,      FROM_RESOURCE_CODE
,      FROM_QUANTITY
,      MINIMUM_TRANSFER_QUANTITY
,      TO_START_DATE
,      TO_END_DATE
,      TO_ORDER_NUMBER
,      TO_OPERATION_SEQ_ID
,      TO_OPERATION_SEQUENCE
,      TO_RESOURCE_SEQUENCE
,      TO_DEPARTMENT
,      TO_RESOURCE_TRANS_ID
,      TO_RESOURCE_ID
,      TO_RESOURCE_CODE
,      TO_QUANTITY
,      DEPENDENCY_TYPE
,      DEPENDENCY_TYPE_ID
,      MINIMUM_TIME_OFFSET
,      MAXIMUM_TIME_OFFSET
,      ACTUAL_TIME_OFFSET
,      PRODUCER_TRANS_ID
,      CONSUMER_TRANS_ID
,      PRODUCER_SR_INSTANCE_ID
,      CONSUMER_SR_INSTANCE_ID
,      PLAN_ID
,      FROM_ORG
,      TO_ORG
,      FROM_ITEM
,      TO_ITEM
,      FROM_ITEM_DESC
,      TO_ITEM_DESC
FROM APPS.MSC_MATERIAL_FLOW_DETAILS_V;

Dependencies

[top of page]

APPS.MSC_MATERIAL_FLOW_DETAILS_V references the following:

APPS: MSC_GET_NAME - show dependent code; MSC_SEGMENT_ALLOCATIONS; MSC_SUPPLIES

APPS.MSC_MATERIAL_FLOW_DETAILS_V is referenced by following:

APPS: MSC_GANTT_UTILS - show dependent code