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: MRP.MRP_AP_APPS_INSTANCES_ALL#

Object Details

Object Name:	MRP_AP_APPS_INSTANCES_ALL#
Object Type:	VIEW
Owner:	MRP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INSTANCE_ID	NUMBER		Yes
LRN	NUMBER
LRD	DATE
INSTANCE_CODE	VARCHAR2	(3)	Yes
M2A_DBLINK	VARCHAR2	(128)
A2M_DBLINK	VARCHAR2	(128)
SN_STATUS	NUMBER		Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
BOM_HOUR_UOM_CODE	VARCHAR2	(3)
MRP_MPS_CONSUMPTION	NUMBER
MRP_SHIP_ARRIVE_FLAG	NUMBER
CRP_SPREAD_LOAD	NUMBER
MSO_ITEM_DMD_PENALTY	NUMBER
MSO_ITEM_CAP_PENALTY	NUMBER
MSO_ORG_DMD_PENALTY	NUMBER
MSO_ORG_ITEM_PENALTY	NUMBER
MSO_ORG_RES_PENALTY	NUMBER
MSO_ORG_TRSP_PENALTY	NUMBER
MSC_AGGREG_RES_NAME	NUMBER
MSO_RES_PENALTY	NUMBER
MSO_SUP_CAP_PENALTY	NUMBER
MSC_BOM_SUBST_PRIORITY	NUMBER
MSO_TRSP_PENALTY	NUMBER
MSC_ALT_BOM_COST	NUMBER
MSO_FCST_PENALTY	NUMBER
MSO_SO_PENALTY	NUMBER
MSC_ALT_OP_RES	NUMBER
MSC_ALT_RES_PRIORITY	NUMBER
MSC_SIMUL_RES_SEQ	NUMBER
MRP_BIS_AV_DISCOUNT	NUMBER
MRP_BIS_PRICE_LIST	NUMBER
MSC_DMD_PRIORITY_FLEX_NUM	NUMBER
MSC_BATCHABLE_FLAG	NUMBER
MSC_BATCHING_WINDOW	NUMBER
MSC_MIN_CAPACITY	NUMBER
MSC_MAX_CAPACITY	NUMBER
MSC_UNIT_OF_MEASURE	NUMBER
MSC_FCST_PRIORITY_FLEX_NUM	NUMBER
ALLOW_ATP_FLAG	NUMBER		Yes
ALLOW_RELEASE_FLAG	NUMBER		Yes
VALIDATION_ORG_ID	NUMBER
MSC_SO_OFFSET_DAYS	NUMBER
ITEM_NAME_FROM_KFV	VARCHAR2	(2000)
STAGING_COPY_ENABLED	NUMBER
STAGING_COPY_COMPLETE	NUMBER
RP_SOURCE_IND	NUMBER

Query Text

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


SELECT INSTANCE_ID
,      LRN
,      LRD
,      INSTANCE_CODE
,      M2A_DBLINK
,      A2M_DBLINK
,      SN_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BOM_HOUR_UOM_CODE
,      MRP_MPS_CONSUMPTION
,      MRP_SHIP_ARRIVE_FLAG
,      CRP_SPREAD_LOAD
,      MSO_ITEM_DMD_PENALTY
,      MSO_ITEM_CAP_PENALTY
,      MSO_ORG_DMD_PENALTY
,      MSO_ORG_ITEM_PENALTY
,      MSO_ORG_RES_PENALTY
,      MSO_ORG_TRSP_PENALTY
,      MSC_AGGREG_RES_NAME
,      MSO_RES_PENALTY
,      MSO_SUP_CAP_PENALTY
,      MSC_BOM_SUBST_PRIORITY
,      MSO_TRSP_PENALTY
,      MSC_ALT_BOM_COST
,      MSO_FCST_PENALTY
,      MSO_SO_PENALTY
,      MSC_ALT_OP_RES
,      MSC_ALT_RES_PRIORITY
,      MSC_SIMUL_RES_SEQ
,      MRP_BIS_AV_DISCOUNT
,      MRP_BIS_PRICE_LIST
,      MSC_DMD_PRIORITY_FLEX_NUM
,      MSC_BATCHABLE_FLAG
,      MSC_BATCHING_WINDOW
,      MSC_MIN_CAPACITY
,      MSC_MAX_CAPACITY
,      MSC_UNIT_OF_MEASURE
,      MSC_FCST_PRIORITY_FLEX_NUM
,      ALLOW_ATP_FLAG
,      ALLOW_RELEASE_FLAG
,      VALIDATION_ORG_ID
,      MSC_SO_OFFSET_DAYS
,      ITEM_NAME_FROM_KFV
,      STAGING_COPY_ENABLED
,      STAGING_COPY_COMPLETE
,      RP_SOURCE_IND
FROM MRP.MRP_AP_APPS_INSTANCES_ALL#;

Dependencies

[top of page]

MRP.MRP_AP_APPS_INSTANCES_ALL# references the following:

MRP: MRP_AP_APPS_INSTANCES_ALL

MRP.MRP_AP_APPS_INSTANCES_ALL# is referenced by following:

APPS: MRP_AP_APPS_INSTANCES_ALL