[Home] [Help] [Dependency Information]
Object Name: | MRP_AP_APPS_INSTANCES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 | ||
MSC_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. | |
MSC_SO_OFFSET_DAYS | NUMBER | Profile value MSC_SO_OFFSET_DAYS | ||
ITEM_NAME_FROM_KFV | VARCHAR2 | (2000) | Item Name From Kfv |
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
, MSC_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
, MSC_SO_OFFSET_DAYS
, ITEM_NAME_FROM_KFV
FROM APPS.MRP_AP_APPS_INSTANCES;
|
|
|