VIEW: MRP.MRP_AP_APPS_INSTANCES_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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