View: MRP_ATP_PROPERTIES_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRP_ATP_PROPERTIES_V

View Text

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.BASIS_TYPE
, NULL
, NULL
, MFG3.MEANING)
, DECODE(MRP.BATCHABLE_FLAG
, NULL
, NULL
, MFG1.MEANING)
, MRP.ALLOCATION_RULE
, MRP.PLAN_NAME
, MRP.VOLUME_UOM
, MRP.WEIGHT_UOM
FROM MRP_ATP_DETAILS_TEMP MRP
, FND_COMMON_LOOKUPS FND1
, FND_COMMON_LOOKUPS FND2
, MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
, MFG_LOOKUPS MFG3
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'
AND NVL(MRP.BASIS_TYPE
, 1) = MFG3.LOOKUP_CODE
AND MFG3.LOOKUP_TYPE='MSC_RES_BASIS_TYPE'

Columns