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]

TABLE: MRP.MRP_AP_APPS_INSTANCES_ALL

Object Details

Object Name:	MRP_AP_APPS_INSTANCES_ALL
Object Type:	TABLE
Owner:	MRP
Subobject Name:
Status:	VALID

This table provides the information about the application instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Unique Key: MRP_AP_APPS_INSTANCES_ALL_U1

INSTANCE_ID
INSTANCE_CODE
A2M_DBLINK

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_AP_APPS_INSTANCES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INSTANCE_ID INSTANCE_CODE A2M_DBLINK

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER		Yes	Instance identifier
LRN	NUMBER			Last refresh number
LRD	DATE			Last refresh date
INSTANCE_CODE	VARCHAR2	(3)	Yes	Unique code assigned to the application instance
M2A_DBLINK	VARCHAR2	(128)		MSC-to-APPS's database link
A2M_DBLINK	VARCHAR2	(128)		APPS-to-MSC's database link
SN_STATUS	NUMBER		Yes	Indicate the status of the snapshot
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
BOM_HOUR_UOM_CODE	VARCHAR2	(3)		Profile option value for BOM_HOUR_UOM_CODE
MRP_MPS_CONSUMPTION	NUMBER			Profile option value for MRP_MPS_CONSUMPTION
MRP_SHIP_ARRIVE_FLAG	NUMBER			Profile option value for MRP_SHIP_ARRIVE_FLAG
CRP_SPREAD_LOAD	NUMBER			Profile option value for CRP_SPREAD_LOAD
MSO_ITEM_DMD_PENALTY	NUMBER			Profile option value for MSO_ITEM_DMD_PENALTY
MSO_ITEM_CAP_PENALTY	NUMBER			Profile option value for MSO_ITEM_CAP_PENALTY
MSO_ORG_DMD_PENALTY	NUMBER			Profile option value for MSO_ORG_DMD_PENALTY
MSO_ORG_ITEM_PENALTY	NUMBER			Profile option value for MSO_ORG_ITEM_PENALTY
MSO_ORG_RES_PENALTY	NUMBER			Profile option value for MSO_ORG_RES_PENALTY
MSO_ORG_TRSP_PENALTY	NUMBER			Profile option value for MSO_ORG_TRSP_PENALTY
MSC_AGGREG_RES_NAME	NUMBER			Profile option value for MSC_AGGREG_RES_NAME
MSO_RES_PENALTY	NUMBER			Profile option value for MSO_RES_PENALTY
MSO_SUP_CAP_PENALTY	NUMBER			Profile option value for MSO_SUP_CAP_PENALTY
MSC_BOM_SUBST_PRIORITY	NUMBER			Profile option value for MSC_BOM_SUBST_PRIORITY
MSO_TRSP_PENALTY	NUMBER			Profile option value for MSO_TRSP_PENALTY
MSC_ALT_BOM_COST	NUMBER			Profile option value for MSC_ALT_BOM_COST
MSO_FCST_PENALTY	NUMBER			Profile option value for MSO_FCST_PENALTY
MSO_SO_PENALTY	NUMBER			Profile option value for MSO_SO_PENALTY
MSC_ALT_OP_RES	NUMBER			Profile option value for MSC_ALT_OP_RES
MSC_ALT_RES_PRIORITY	NUMBER			Profile option value for MSC_ALT_RES_PRIORITY
MSC_SIMUL_RES_SEQ	NUMBER			Profile option value for MSC_SIMUL_RES_SEQ
MRP_BIS_AV_DISCOUNT	NUMBER			Profile option value for MRP_BIS_AV_DISCOUNT
MRP_BIS_PRICE_LIST	NUMBER			Profile option value for MRP_BIS_PRICE_LIST
MSC_DMD_PRIORITY_FLEX_NUM	NUMBER			Profile option value for MSC_DMD_PRIORITY_FLEX_NUM
MSC_BATCHABLE_FLAG	NUMBER			Profile value MSC_BATCHABLE_FLAG
MSC_BATCHING_WINDOW	NUMBER			Profile value MSC_BATCHING_WINDOW
MSC_MIN_CAPACITY	NUMBER			Profile value MSC_MIN_CAPACITY
MSC_MAX_CAPACITY	NUMBER			Profile value MSC_MAX_CAPACITY
MSC_UNIT_OF_MEASURE	NUMBER			Profile value MSC_UNIT_OF_MEASURE
MSC_FCST_PRIORITY_FLEX_NUM	NUMBER			Profile value MSC_FCST_PRIORITY_FLEX_NUM
ALLOW_ATP_FLAG	NUMBER		Yes	Specifies the destination instance that should be considered in the ATP process from the source instance in the Application Instances form
ALLOW_RELEASE_FLAG	NUMBER		Yes	Allow Release to source instance if this flag is set to Yes.
VALIDATION_ORG_ID	NUMBER			Profile value MSC_ORG_FOR_BOM_EXPLOSION
MSC_SO_OFFSET_DAYS	NUMBER			Profile value MSC_SO_OFFSET_DAYS
ITEM_NAME_FROM_KFV	VARCHAR2	(2000)		Item Name From Kfv
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 does not reference any database object

MRP.MRP_AP_APPS_INSTANCES_ALL is referenced by following:

MRP: MRP_AP_APPS_INSTANCES_ALL#