VIEW: APPS.MRP_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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