VIEW: APPS.MRP_ATP_PROPERTIES_V

Source

View Text - Preformatted

SELECT mrp.SESSION_ID, mrp.PEGGING_ID, mrp.FIXED_LEAD_TIME, mrp.VARIABLE_LEAD_TIME, mrp.PREPROCESSING_LEAD_TIME, mrp.PROCESSING_LEAD_TIME, mrp.POSTPROCESSING_LEAD_TIME, mrp.INTRANSIT_LEAD_TIME, mrp.SHIP_METHOD, mrp.PTF_DATE, mrp.REQUIRED_QUANTITY, mrp.REQUIRED_DATE, mrp.ATP_RULE_NAME, mrp.INFINITE_TIME_FENCE, mrp.SUBSTITUTION_WINDOW, DECODE(mrp.ROUNDING_CONTROL, NULL,NULL, mfg2.meaning), mrp.WEIGHT_CAPACITY, mrp.VOLUME_CAPACITY, DECODE(mrp.ATP_FLAG, NULL, NULL, fnd1.meaning), DECODE(mrp.ATP_COMPONENT_FLAG, NULL, NULL, fnd2.meaning), mrp.OPERATION_SEQUENCE_ID, mrp.USAGE, mrp.OFFSET, mrp.EFFICIENCY * 100, mrp.UTILIZATION * 100 , mrp.OWNING_DEPARTMENT, mrp.REVERSE_CUM_YIELD, decode(mrp.organization_type ,2 , mrp_get_project.lookup_meaning('MRP_OPM_ORG_BASIS_TYPE', mrp.BASIS_TYPE) ,1 , mrp_get_project.lookup_meaning('MRP_DIS_ORG_BASIS_TYPE', mrp.BASIS_TYPE) ), DECODE(mrp.BATCHABLE_FLAG, NULL, NULL, mfg1.meaning), mrp.ALLOCATION_RULE, mrp.PLAN_NAME, mrp.VOLUME_UOM, mrp.WEIGHT_UOM, mrp.aggregate_time_fence_date , mrp.component_yield_factor , mrp.rounding_direction , decode(mrp.organization_type ,2 ,decode(mrp.scaling_type,null, null, mrp_get_project.lookup_meaning('MRP_OPM_ORG_SCALING_TYPE', decode(mrp.scaling_type, 0,0,2,0,1,1,3,1,4,2,5,2))) ,1, mrp_get_project.lookup_meaning('MRP_DIS_ORG_BASIS_TYPE', mrp.SCALING_TYPE) ) scaling_type , mrp.scale_rounding_variance , mrp.scale_multiple from mrp_atp_details_temp mrp, fnd_common_lookups fnd1, fnd_common_lookups fnd2, mfg_lookups mfg1, mfg_lookups mfg2 WHERE mrp.record_type = 3 AND NVL(mrp.atp_flag, 'N') = fnd1.lookup_code AND fnd1.application_id = 401 AND fnd1.lookup_type = 'ATP_FLAG' AND NVL(mrp.atp_component_flag, 'N') = fnd2.lookup_code AND fnd2.application_id = 401 AND fnd1.lookup_type = 'ATP_FLAG' AND NVL(mrp.batchable_flag, 2) = mfg1.lookup_code AND mfg1.lookup_type = 'SYS_YES_NO' AND NVL(mrp.ROUNDING_CONTROL,2)=mfg2.lookup_code AND mfg2.lookup_type='SYS_YES_NO'

View Text - HTML Formatted

SELECT MRP.SESSION_ID
, MRP.PEGGING_ID
, MRP.FIXED_LEAD_TIME
, MRP.VARIABLE_LEAD_TIME
, MRP.PREPROCESSING_LEAD_TIME
, MRP.PROCESSING_LEAD_TIME
, MRP.POSTPROCESSING_LEAD_TIME
, MRP.INTRANSIT_LEAD_TIME
, MRP.SHIP_METHOD
, MRP.PTF_DATE
, MRP.REQUIRED_QUANTITY
, MRP.REQUIRED_DATE
, MRP.ATP_RULE_NAME
, MRP.INFINITE_TIME_FENCE
, MRP.SUBSTITUTION_WINDOW
, DECODE(MRP.ROUNDING_CONTROL
, NULL
, NULL
, MFG2.MEANING)
, MRP.WEIGHT_CAPACITY
, MRP.VOLUME_CAPACITY
, DECODE(MRP.ATP_FLAG
, NULL
, NULL
, FND1.MEANING)
, DECODE(MRP.ATP_COMPONENT_FLAG
, NULL
, NULL
, FND2.MEANING)
, MRP.OPERATION_SEQUENCE_ID
, MRP.USAGE
, MRP.OFFSET
, MRP.EFFICIENCY * 100
, MRP.UTILIZATION * 100
, MRP.OWNING_DEPARTMENT
, MRP.REVERSE_CUM_YIELD
, DECODE(MRP.ORGANIZATION_TYPE
, 2
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_OPM_ORG_BASIS_TYPE'
, MRP.BASIS_TYPE)
, 1
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_DIS_ORG_BASIS_TYPE'
, MRP.BASIS_TYPE) )
, DECODE(MRP.BATCHABLE_FLAG
, NULL
, NULL
, MFG1.MEANING)
, MRP.ALLOCATION_RULE
, MRP.PLAN_NAME
, MRP.VOLUME_UOM
, MRP.WEIGHT_UOM
, MRP.AGGREGATE_TIME_FENCE_DATE
, MRP.COMPONENT_YIELD_FACTOR
, MRP.ROUNDING_DIRECTION
, DECODE(MRP.ORGANIZATION_TYPE
, 2
, DECODE(MRP.SCALING_TYPE
, NULL
, NULL
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_OPM_ORG_SCALING_TYPE'
, DECODE(MRP.SCALING_TYPE
, 0
, 0
, 2
, 0
, 1
, 1
, 3
, 1
, 4
, 2
, 5
, 2)))
, 1
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_DIS_ORG_BASIS_TYPE'
, MRP.SCALING_TYPE) ) SCALING_TYPE
, MRP.SCALE_ROUNDING_VARIANCE
, MRP.SCALE_MULTIPLE
FROM MRP_ATP_DETAILS_TEMP MRP
, FND_COMMON_LOOKUPS FND1
, FND_COMMON_LOOKUPS FND2
, MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
WHERE MRP.RECORD_TYPE = 3
AND NVL(MRP.ATP_FLAG
, 'N') = FND1.LOOKUP_CODE
AND FND1.APPLICATION_ID = 401
AND FND1.LOOKUP_TYPE = 'ATP_FLAG'
AND NVL(MRP.ATP_COMPONENT_FLAG
, 'N') = FND2.LOOKUP_CODE
AND FND2.APPLICATION_ID = 401
AND FND1.LOOKUP_TYPE = 'ATP_FLAG'
AND NVL(MRP.BATCHABLE_FLAG
, 2) = MFG1.LOOKUP_CODE
AND MFG1.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(MRP.ROUNDING_CONTROL
, 2)=MFG2.LOOKUP_CODE
AND MFG2.LOOKUP_TYPE='SYS_YES_NO'