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_SUPPLIES_OUTBOUND_V

Object Details

Object Name:	MSC_SUPPLIES_OUTBOUND_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_SUPPLIES_OUTBOUND_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view lists all the supplies for the plan. This view is used in XML-outbound

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier of the item org
PLAN_ID	NUMBER		Yes	Plan identifier
TRANSACTION_ID	NUMBER		Yes	Unique identifier for the row
ORGANIZATION_ID	NUMBER		Yes	Organization ID
ORGANIZATION_CODE	VARCHAR2	(7)		Organization Code
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM_NAME	VARCHAR2	(250)		Item Name
REVISION	VARCHAR2	(10)		Inventory item revision code
UNIT_NUMBER	VARCHAR2	(30)		Unit number of the item
STATUS	VARCHAR2	(6)		Attribute used for online replanning
NEW_SCHEDULE_DATE	DATE		Yes	End date of the supply (Completion date of first unit)
LAST_UNIT_START_DATE	DATE			Last unit start date for recommended repetitive schedule
ORDER_QUANTITY	NUMBER			Quantity ordered
OLD_ORDER_QUANTITY	NUMBER			Old supply quantity
LINE_TYPE	NUMBER			Implement order type None (1), Purchase requisition (2), Discrete job (3)
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_NAME	VARCHAR2	(4000)		Supplier name
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
SUPPLIER_SITE_CODE	VARCHAR2	(4000)		Supplier site code
IMPLEMENTED_QUANTITY	VARCHAR2	(1)		Planned order implemented quantity
FIRM_PLANNED_TYPE	NUMBER		Yes	Flag indicating whether the order is firm
FIRM_FLAG	VARCHAR2	(3)		Flag to indicate the status of FIRM_PLANNED_TYPE. If FIRM_PLANNED_TYPE is 1 then it returns 'yes' otherwise 'no'
RELEASE_STATUS	NUMBER			Flag indicating release status
NEW_SHIP_DATE	DATE			New ship date
PROJECT_ID	NUMBER	(15)		Project identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project number
TASK_ID	NUMBER	(15)		Task identifier
TASK_NUMBER	VARCHAR2	(4000)		Task number
PLANNING_GROUP	VARCHAR2	(30)		Project planning group
DEMAND_CLASS	VARCHAR2	(34)		Demand class code
UOM_CODE	VARCHAR2	(3)	Yes	UOM code
SOURCE_SUPPLIER_ID	NUMBER			Source supplier identifier
SOURCE_SUPPLIER_SITE_ID	NUMBER			Source supplier site identifier

Query Text

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


SELECT SR_INSTANCE_ID
,      PLAN_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      REVISION
,      UNIT_NUMBER
,      STATUS
,      NEW_SCHEDULE_DATE
,      LAST_UNIT_START_DATE
,      ORDER_QUANTITY
,      OLD_ORDER_QUANTITY
,      LINE_TYPE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      IMPLEMENTED_QUANTITY
,      FIRM_PLANNED_TYPE
,      FIRM_FLAG
,      RELEASE_STATUS
,      NEW_SHIP_DATE
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      PLANNING_GROUP
,      DEMAND_CLASS
,      UOM_CODE
,      SOURCE_SUPPLIER_ID
,      SOURCE_SUPPLIER_SITE_ID
FROM APPS.MSC_SUPPLIES_OUTBOUND_V;

Dependencies

[top of page]

APPS.MSC_SUPPLIES_OUTBOUND_V references the following:

APPS: MSC_APPS_INSTANCES; MSC_ST_UTIL - show dependent code; MSC_SUPPLIES; MSC_SYSTEM_ITEMS; MSC_TRADING_PARTNERS

APPS.MSC_SUPPLIES_OUTBOUND_V is not referenced by any database object