Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP parameters view |
Implementation/DBA Data: | APPS.MRP_PARAMETERS_V |
SELECT M.ROWID ROW_ID
, M.ORGANIZATION_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.DEMAND_TIME_FENCE_FLAG
, M.PLANNING_TIME_FENCE_FLAG
, M.OPERATION_SCHEDULE_TYPE
, M.REPETITIVE_HORIZON1
, M.REPETITIVE_HORIZON2
, M.REPETITIVE_BUCKET_SIZE1
, M.REPETITIVE_BUCKET_SIZE2
, M.REPETITIVE_BUCKET_SIZE3
, M.REPETITIVE_ANCHOR_DATE
, M.CONSIDER_WIP
, M.CONSIDER_PO
, M.SNAPSHOT_LOCK
, M.PLAN_SAFETY_STOCK
, M.CONSIDER_RESERVATIONS
, M.PART_INCLUDE_TYPE
, M.DEFAULT_ABC_ASSIGNMENT_GROUP
, MTL.ASSIGNMENT_GROUP_NAME ABC_ASSIGNMENT_GROUP_NAME
, M.PERIOD_TYPE
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.RESCHED_ASSUMPTION
, M.PLAN_DATE_DEFAULT_TYPE
, M.INCLUDE_REP_SUPPLY_DAYS
, M.INCLUDE_MDS_DAYS
FROM MTL_ABC_ASSIGNMENT_GROUPS MTL
, MRP_PARAMETERS M
WHERE MTL.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND MTL.ASSIGNMENT_GROUP_ID(+) = M.DEFAULT_ABC_ASSIGNMENT_GROUP