VIEW: APPS.MRP_AP_APPS_INSTANCES

Source

View Text - Preformatted

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, msc_so_offset_days, item_name_from_kfv from mrp_ap_apps_instances_all WHERE allow_atp_flag=1

View Text - HTML Formatted

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
, MSC_SO_OFFSET_DAYS
, ITEM_NAME_FROM_KFV
FROM MRP_AP_APPS_INSTANCES_ALL
WHERE ALLOW_ATP_FLAG=1