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.MRPFV_PLAN_SUPPLIES

Object Details

Object Name:	MRPFV_PLAN_SUPPLIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRPFV_PLAN_SUPPLIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows the actual or planned replenishment of a product or component.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)
PLAN_NAME	VARCHAR2	(10)	Yes
_KF:ITEM_NUMBER	CHAR	(20)
ORDER_TYPE	VARCHAR2	(80)	Yes
SUGGESTED_DUE_DATE	DATE		Yes
QUANTITY_RATE	NUMBER		Yes
ORDER_NUMBER	VARCHAR2	(240)
_LA:FIRM_FLAG	CHAR	(56)
FIRM_DATE	DATE
FIRM_QUANTITY	NUMBER
LINE_NAME	VARCHAR2	(10)
SOURCE_ORGANIZATION_CODE	VARCHAR2	(3)
SOURCE_ORGANIZATION_NAME	VARCHAR2	(240)
SOURCE_SUPPLIER_NAME	VARCHAR2	(240)
SOURCE_SUPPLIER_SITE	VARCHAR2	(15)
PROJECT_NUMBER	VARCHAR2	(4000)
TASK_NUMBER	VARCHAR2	(4000)
SCHEDULE_GROUP	VARCHAR2	(30)
BUILD_SEQUENCE	NUMBER
ALTERNATE_BOM	VARCHAR2	(10)
ALTERNATE_ROUTING	VARCHAR2	(10)
_LA:SELECT_FOR_RELEASE_FLAG	CHAR	(53)
IMPLEMENT_DATE	DATE
IMPLEMENT_QUANTITY_RATE	NUMBER
_LA:IMPLEMENT_AS	CHAR	(67)
_LA:IMPLEMENT_STATUS_CODE	CHAR	(64)
COMPRESSION_DAYS	NUMBER
DAYS_FROM_TODAY	NUMBER
LAST_UNIT_START_DATE	DATE
LAST_UNIT_COMPLETION_DATE	DATE
FIRST_UNIT_START_DATE	DATE
OLD_DUE_DATE	DATE
PLANNER	VARCHAR2	(10)
PROCESS_DAYS	NUMBER
_LA:RESCHEDULED_FLAG	CHAR	(55)
SUGGESTED_DOCK_DATE	DATE
SUGGESTED_ORDER_DATE	DATE
SUGGESTED_START_DATE	DATE
ORIGINAL_QUANTITY_RATE	NUMBER
IMPLEMENTED_QUANTITY	NUMBER
QUANTITY_IN_PROCESS	NUMBER
PLANNING_GROUP	VARCHAR2	(30)
IMPLEMENT_BUILD_SEQUENCE	NUMBER
IMPLEMENT_ALTERNATE_BOM	VARCHAR2	(10)
IMPLEMENT_ALTERNATE_ROUTING	VARCHAR2	(10)
IMPLEMENT_DEMAND_CLASS	VARCHAR2	(30)
IMPLEMENT_SCHEDULE_GROUP_NAME	VARCHAR2	(30)
_LA:IMPLEMENT_FIRM_FLAG	CHAR	(53)
IMPLEMENT_PROJECT_NUMBER	VARCHAR2	(4000)
IMPLEMENT_TASK_NUMBER	VARCHAR2	(4000)
IMPLEMENT_ORGANIZATION_CODE	VARCHAR2	(3)
IMPLEMENT_ORGANIZATION_NAME	VARCHAR2	(240)
IMPLEMENT_SUPPLIER_NAME	VARCHAR2	(240)
IMPLEMENT_SUPPLIER_SITE	VARCHAR2	(15)
IMPLEMENT_LINE_NAME	VARCHAR2	(10)
IMPLEMENT_WIP_CLASS_CODE	VARCHAR2	(10)
UNIT_NUMBER	VARCHAR2	(30)
IMPLEMENT_UNIT_NUMBER	VARCHAR2	(30)
PLAN_SUPPLY_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_SUPPLIER_ID	NUMBER
SOURCE_SUPPLIER_SITE_ID	NUMBER
IMPLEMENT_PROJECT_ID	NUMBER
IMPLEMENT_TASK_ID	NUMBER
IMPLEMENT_SCHEDULE_GROUP_ID	NUMBER
IMPLEMENT_SOURCE_ORG_ID	NUMBER
IMPLEMENT_SUPPLIER_ID	NUMBER
IMPLEMENT_SUPPLIER_SITE_ID	NUMBER
IMPLEMENT_MFG_LINE_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
MFG_LINE_ID	NUMBER
PO_LINE_ID	NUMBER
SHIPMENT_LINE_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
MFG_ORDER_ID	NUMBER
SCHEDULE_GROUP_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes

Query Text

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


SELECT ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      PLAN_NAME
,      _KF:ITEM_NUMBER
,      ORDER_TYPE
,      SUGGESTED_DUE_DATE
,      QUANTITY_RATE
,      ORDER_NUMBER
,      _LA:FIRM_FLAG
,      FIRM_DATE
,      FIRM_QUANTITY
,      LINE_NAME
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      SOURCE_SUPPLIER_NAME
,      SOURCE_SUPPLIER_SITE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      SCHEDULE_GROUP
,      BUILD_SEQUENCE
,      ALTERNATE_BOM
,      ALTERNATE_ROUTING
,      _LA:SELECT_FOR_RELEASE_FLAG
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY_RATE
,      _LA:IMPLEMENT_AS
,      _LA:IMPLEMENT_STATUS_CODE
,      COMPRESSION_DAYS
,      DAYS_FROM_TODAY
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      OLD_DUE_DATE
,      PLANNER
,      PROCESS_DAYS
,      _LA:RESCHEDULED_FLAG
,      SUGGESTED_DOCK_DATE
,      SUGGESTED_ORDER_DATE
,      SUGGESTED_START_DATE
,      ORIGINAL_QUANTITY_RATE
,      IMPLEMENTED_QUANTITY
,      QUANTITY_IN_PROCESS
,      PLANNING_GROUP
,      IMPLEMENT_BUILD_SEQUENCE
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      IMPLEMENT_DEMAND_CLASS
,      IMPLEMENT_SCHEDULE_GROUP_NAME
,      _LA:IMPLEMENT_FIRM_FLAG
,      IMPLEMENT_PROJECT_NUMBER
,      IMPLEMENT_TASK_NUMBER
,      IMPLEMENT_ORGANIZATION_CODE
,      IMPLEMENT_ORGANIZATION_NAME
,      IMPLEMENT_SUPPLIER_NAME
,      IMPLEMENT_SUPPLIER_SITE
,      IMPLEMENT_LINE_NAME
,      IMPLEMENT_WIP_CLASS_CODE
,      UNIT_NUMBER
,      IMPLEMENT_UNIT_NUMBER
,      PLAN_SUPPLY_ID
,      ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUPPLIER_ID
,      SOURCE_SUPPLIER_SITE_ID
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_SUPPLIER_ID
,      IMPLEMENT_SUPPLIER_SITE_ID
,      IMPLEMENT_MFG_LINE_ID
,      INVENTORY_ITEM_ID
,      MFG_LINE_ID
,      PO_LINE_ID
,      SHIPMENT_LINE_ID
,      REQUISITION_LINE_ID
,      MFG_ORDER_ID
,      SCHEDULE_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPFV_PLAN_SUPPLIES;

Dependencies

[top of page]

APPS.MRPFV_PLAN_SUPPLIES references the following:

APPS: FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS; MFG_LOOKUPS; MRP_GET_PROJECT - show dependent code; MRP_ITEM_PURCHASE_ORDERS; MRP_ITEM_WIP_ENTITIES; MRP_PLANS; MRP_PLAN_ORGANIZATIONS; MRP_RECOMMENDATIONS; MRP_SYSTEM_ITEMS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; PO_VENDORS; PO_VENDOR_SITES_ALL; WIP_LINES; WIP_SCHEDULE_GROUPS

APPS.MRPFV_PLAN_SUPPLIES is not referenced by any database object