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

Object Details

Object Name:	MRP_ORDERS_SC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_ORDERS_SC_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
SOURCE_TABLE	VARCHAR2	(22)
ROW_ID	ROWID	(10)
TRANSACTION_ID	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
INVENTORY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
PLAN_ORGANIZATION_ID	NUMBER
COMPILE_DESIGNATOR	VARCHAR2	(10)
NEW_DUE_DATE	DATE
OLD_DUE_DATE	DATE
NEW_START_DATE	DATE
DISPOSITION_ID	NUMBER
ORDER_NUMBER	VARCHAR2	(240)
DISPOSITION_STATUS_TYPE	NUMBER
ORDER_TYPE	NUMBER
ORDER_TYPE_TEXT	VARCHAR2	(80)
VENDOR_ID	NUMBER
QUANTITY_RATE	NUMBER
OLD_ORDER_QUANTITY	NUMBER
NEW_ORDER_DATE	DATE
FIRM_PLANNED_TYPE	NUMBER
RESCHEDULED_FLAG	NUMBER
NEW_PROCESSING_DAYS	NUMBER
IMPLEMENTED_QUANTITY	NUMBER
LAST_UNIT_COMPLETION_DATE	DATE
FIRST_UNIT_START_DATE	DATE
LAST_UNIT_START_DATE	DATE
NEW_DOCK_DATE	DATE
QUANTITY_IN_PROCESS	NUMBER
FIRM_QUANTITY	NUMBER
FIRM_DATE	DATE
LINE_ID	NUMBER
LINE_CODE	VARCHAR2	(10)
IMPLEMENT_DEMAND_CLASS	VARCHAR2	(30)
ITEM_SEGMENTS	VARCHAR2	(40)
IMPLEMENT_DATE	DATE
IMPLEMENT_QUANTITY_RATE	NUMBER
IMPLEMENT_FIRM	NUMBER
IMPLEMENT_PROCESSING_DAYS	NUMBER
IMPLEMENT_WIP_CLASS_CODE	VARCHAR2	(10)
IMPLEMENT_JOB_NAME	VARCHAR2	(240)
IMPLEMENT_LINE_ID	NUMBER
IMPLEMENT_STATUS_CODE	NUMBER
IMPLEMENT_LOCATION_ID	NUMBER
RELEASE_STATUS	NUMBER
IMPLEMENT_AS	NUMBER
IMPLEMENT_AS_TEXT	VARCHAR2	(80)
PLANNER_CODE	VARCHAR2	(10)
USING_ASSEMBLY_ITEM_ID	NUMBER
CATEGORY	NUMBER
MRP_PLANNING_CODE	NUMBER
REPETITIVE_TYPE	NUMBER
BUILD_IN_WIP_FLAG	NUMBER
PURCHASING_ENABLED_FLAG	NUMBER
PLANNING_MAKE_BUY_CODE	NUMBER
DAYS_FROM_TODAY	NUMBER
BOM_ITEM_TYPE	NUMBER
BASE_ITEM_ID	NUMBER
WIP_SUPPLY_TYPE	NUMBER
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_ORGANIZATION_CODE	VARCHAR2	(3)
STATUS_CODE	NUMBER
USING_ASSEMBLY_ITEM_NAME	VARCHAR2	(40)
FULL_PEGGING	NUMBER
SOURCE_SCHEDULE	VARCHAR2	(10)
SOURCE_VENDOR_ID	NUMBER
SOURCE_VENDOR_NAME	VARCHAR2	(240)
SOURCE_VENDOR_SITE_ID	NUMBER
SOURCE_VENDOR_SITE_CODE	VARCHAR2	(4000)
IMPLEMENT_SOURCE_ORG_ID	NUMBER
IMPLEMENT_VENDOR_ID	NUMBER
IMPLEMENT_VENDOR_SITE_ID	NUMBER
IN_SOURCE_PLAN	NUMBER
SCHEDULE_COMPRESSION_DAYS	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
PROJECT_NUMBER	VARCHAR2	(4000)
TASK_NUMBER	VARCHAR2	(4000)
IMPLEMENT_PROJECT_ID	NUMBER
IMPLEMENT_TASK_ID	NUMBER
PLANNING_GROUP	VARCHAR2	(30)
STATUS	NUMBER
APPLIED	NUMBER
RELEASE_TIME_FENCE_CODE	NUMBER
IMPLEMENT_SCHEDULE_GROUP_ID	NUMBER
IMPLEMENT_BUILD_SEQUENCE	NUMBER
BUILD_SEQUENCE	NUMBER
SCHEDULE_GROUP_ID	NUMBER
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)
IMPLEMENT_ALTERNATE_BOM	VARCHAR2	(10)
IMPLEMENT_ALTERNATE_ROUTING	VARCHAR2	(10)
SCHEDULE_GROUP_NAME	VARCHAR2	(30)
IMPLEMENT_EMPLOYEE_ID	NUMBER
CFM_ROUTING_FLAG	NUMBER
BUYER_NAME	VARCHAR2	(240)
RELEASE_ERRORS	VARCHAR2	(2000)
REL_ALL_QTY	NUMBER
UNIT_NUMBER	VARCHAR2	(30)
IMPLEMENT_UNIT_NUMBER	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(240)
PLANNING_GROUP_HIDDEN	VARCHAR2	(30)
BUYER_NAME_HIDDEN	VARCHAR2	(240)
PLANNER_CODE_HIDDEN	VARCHAR2	(10)
PROJECT_ID_HIDDEN	NUMBER
TASK_ID_HIDDEN	NUMBER
LENDING_PROJECT_NUMBER	VARCHAR2	(4000)
LENDING_TASK_NUMBER	VARCHAR2	(4000)
SUPPLY_AVAIL_DATE	DATE
OLD_DOCK_DATE	DATE

Query Text

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


SELECT SOURCE_TABLE
,      ROW_ID
,      TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      NEW_DUE_DATE
,      OLD_DUE_DATE
,      NEW_START_DATE
,      DISPOSITION_ID
,      ORDER_NUMBER
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      VENDOR_ID
,      QUANTITY_RATE
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_DATE
,      FIRM_PLANNED_TYPE
,      RESCHEDULED_FLAG
,      NEW_PROCESSING_DAYS
,      IMPLEMENTED_QUANTITY
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      NEW_DOCK_DATE
,      QUANTITY_IN_PROCESS
,      FIRM_QUANTITY
,      FIRM_DATE
,      LINE_ID
,      LINE_CODE
,      IMPLEMENT_DEMAND_CLASS
,      ITEM_SEGMENTS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY_RATE
,      IMPLEMENT_FIRM
,      IMPLEMENT_PROCESSING_DAYS
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_LINE_ID
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_LOCATION_ID
,      RELEASE_STATUS
,      IMPLEMENT_AS
,      IMPLEMENT_AS_TEXT
,      PLANNER_CODE
,      USING_ASSEMBLY_ITEM_ID
,      CATEGORY
,      MRP_PLANNING_CODE
,      REPETITIVE_TYPE
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      DAYS_FROM_TODAY
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      WIP_SUPPLY_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      STATUS_CODE
,      USING_ASSEMBLY_ITEM_NAME
,      FULL_PEGGING
,      SOURCE_SCHEDULE
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_NAME
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_VENDOR_SITE_CODE
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_VENDOR_ID
,      IMPLEMENT_VENDOR_SITE_ID
,      IN_SOURCE_PLAN
,      SCHEDULE_COMPRESSION_DAYS
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      PLANNING_GROUP
,      STATUS
,      APPLIED
,      RELEASE_TIME_FENCE_CODE
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_BUILD_SEQUENCE
,      BUILD_SEQUENCE
,      SCHEDULE_GROUP_ID
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      SCHEDULE_GROUP_NAME
,      IMPLEMENT_EMPLOYEE_ID
,      CFM_ROUTING_FLAG
,      BUYER_NAME
,      RELEASE_ERRORS
,      REL_ALL_QTY
,      UNIT_NUMBER
,      IMPLEMENT_UNIT_NUMBER
,      DESCRIPTION
,      PLANNING_GROUP_HIDDEN
,      BUYER_NAME_HIDDEN
,      PLANNER_CODE_HIDDEN
,      PROJECT_ID_HIDDEN
,      TASK_ID_HIDDEN
,      LENDING_PROJECT_NUMBER
,      LENDING_TASK_NUMBER
,      SUPPLY_AVAIL_DATE
,      OLD_DOCK_DATE
FROM APPS.MRP_ORDERS_SC_V;

Dependencies

[top of page]

APPS.MRP_ORDERS_SC_V references the following:

APPS: BOM_OPERATIONAL_ROUTINGS; MFG_LOOKUPS; MRP_GET_PROJECT - show dependent code; MRP_GROSS_REQUIREMENTS; MRP_ITEM_PURCHASE_ORDERS; MRP_ITEM_WIP_ENTITIES; MRP_PLANS; MRP_PLAN_ORGANIZATIONS; MRP_RECOMMENDATIONS; MRP_SCHEDULE_DATES; MRP_SUGG_REP_SCHEDULES; MRP_SYSTEM_ITEMS; MTL_PARAMETERS; MTL_SALES_ORDERS; MTL_SYSTEM_ITEMS_B_KFV; PO_VENDORS; WIP_ENTITIES; WIP_LINES; WIP_SCHEDULE_GROUPS

APPS.MRP_ORDERS_SC_V is not referenced by any database object