[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

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

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