[Home] [Help] [Dependency Information]
Object Name: | MRP_AP_APPS_INSTANCES_ALL# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|