View: MRP_ATP_SD_TEMP_V

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

View Text

SELECT MADT.ORDER_LINE_ID
, MADT.SESSION_ID
, MADT.SCENARIO_ID
, MADT.PEGGING_ID
, MADT.PARENT_PEGGING_ID
, MADT.ATP_LEVEL
, MADT.REQUEST_ITEM_ID
, MADT.REQUEST_ITEM_NAME
, MADT.INVENTORY_ITEM_ID
, MADT.INVENTORY_ITEM_NAME
, MADT.ORGANIZATION_ID
, NVL(MADT.ORGANIZATION_CODE
, MADT1.ORGANIZATION_CODE)
, MADT.DEPARTMENT_ID
, MADT1.DEPARTMENT_CODE
, MADT.RESOURCE_ID
, MADT1.RESOURCE_CODE
, MADT.SUPPLIER_ID
, MADT.SUPPLIER_NAME
, MADT.SUPPLIER_SITE_ID
, MADT.SUPPLIER_SITE_NAME
, MADT.FROM_ORGANIZATION_ID
, MADT.FROM_ORGANIZATION_CODE
, MADT.FROM_LOCATION_ID
, MADT.FROM_LOCATION_CODE
, MADT.TO_ORGANIZATION_ID
, MADT.TO_ORGANIZATION_CODE
, MADT.TO_LOCATION_ID
, MADT.TO_LOCATION_CODE
, MADT.SHIP_METHOD
, DECODE(MADT.BATCHABLE_FLAG
, 1
, 'CAPACITY HOURS'
, MADT.UOM_CODE)
, MADT.IDENTIFIER1
, MADT.IDENTIFIER2
, MADT.IDENTIFIER3
, MADT.IDENTIFIER4
, MADT.SUPPLY_DEMAND_TYPE
, MADT.SUPPLY_DEMAND_DATE
, MADT.SUPPLY_DEMAND_QUANTITY
, MADT.SUPPLY_DEMAND_SOURCE_TYPE
, NVL(ML.MEANING
, ML2.MEANING)
, MADT.ALLOCATED_QUANTITY
, MADT.SOURCE_TYPE
, MADT.RECORD_TYPE
, MADT.TOTAL_SUPPLY_QUANTITY
, MADT.TOTAL_DEMAND_QUANTITY
, MADT.PERIOD_START_DATE
, MADT.PERIOD_END_DATE
, MADT.PERIOD_QUANTITY
, MADT.CUMULATIVE_QUANTITY
, MADT.DISPOSITION_TYPE
, MADT.DISPOSITION_NAME
, DECODE(MADT.DEPARTMENT_ID
, NULL
, NVL(MADT1.INVENTORY_ITEM_NAME
, NVL(MAST.INVENTORY_ITEM_NAME
, MADT.INVENTORY_ITEM_NAME))
, DECODE(MADT.RESOURCE_ID
, NULL
, MADT1.DEPARTMENT_CODE
, -1
, MADT1.DEPARTMENT_CODE
, MADT1.DEPARTMENT_CODE||'-'||MADT1.RESOURCE_CODE))
, ML1.MEANING
, MADT.END_PEGGING_ID
, DECODE(MADT.CHAR1
, '-1'
, NULL
, MADT.CHAR1)
, MADT.PLAN_ID
, MADT.DEMAND_CLASS
, MADT.CLASS
, MADT.CUSTOMER_NAME
, MADT.CUSTOMER_SITE_NAME
, DECODE(MADT.SUPPLY_DEMAND_TYPE
, '2'
, 'MSC_SUPPLIES'
, '1'
, 'MSC_DEMANDS')
, MADT.CUSTOMER_ID
, MADT.CUSTOMER_SITE_ID
, DECODE(MADT.DEMAND_CLASS
, '-1'
, NULL
, MADT.DEMAND_CLASS)
, DECODE(MADT.CLASS
, '-1'
, NULL
, MADT.CLASS)
FROM MRP_ATP_DETAILS_TEMP MADT
, MRP_ATP_DETAILS_TEMP MADT1
, MRP_ATP_SCHEDULE_TEMP MAST
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
WHERE ML2.LOOKUP_TYPE(+) = 'MRP_ATP_FORM_TYPE'
AND ML2.LOOKUP_CODE(+) = DECODE(MADT.DEPARTMENT_ID
, NULL
, 25
, DECODE(MADT.SUPPLY_DEMAND_TYPE
, 1
, -1
, 20))
AND ML1.LOOKUP_TYPE = 'MRP_ATP_FORM_TYPE'
AND ML1.LOOKUP_CODE = DECODE(MADT.DEPARTMENT_ID
, NULL
, 10
, 15)
AND ML.LOOKUP_TYPE(+) = DECODE(MADT.SUPPLY_DEMAND_TYPE
, 1
, DECODE(MADT.DEPARTMENT_ID
, NULL
, DECODE(MADT.SUPPLIER_ID
, NULL
, DECODE(MADT.SUPPLY_DEMAND_SOURCE_TYPE
, 1
, 'MRP_PLANNED_ORDER_DEMAND'
, 3
, 'MRP_PLANNED_ORDER_DEMAND'
, 25
, 'MRP_PLANNED_ORDER_DEMAND'
, 'MRP_DEMAND_ORIGINATION')
, 'MRP_ORDER_TYPE')
, 'MRP_ORDER_TYPE')
, 'MRP_ORDER_TYPE')
AND ML.LOOKUP_CODE(+) = MADT.SUPPLY_DEMAND_SOURCE_TYPE
AND MAST.END_PEGGING_ID(+) = MADT.END_PEGGING_ID
AND MAST.SESSION_ID(+) = MADT.SESSION_ID
AND MADT1.PEGGING_ID(+) = MADT.PEGGING_ID
AND MADT1.END_PEGGING_ID(+) = MADT.END_PEGGING_ID
AND MADT1.RECORD_TYPE(+) = 3
AND MADT.RECORD_TYPE = 2 ORDER BY MADT.SUPPLY_DEMAND_DATE
, MADT.SUPPLY_DEMAND_SOURCE_TYPE_NAME
, MADT. SUPPLY_DEMAND_QUANTITY

Columns