Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | ATP period view |
Implementation/DBA Data: | APPS.MRP_ATP_PERIOD_V |
SELECT DISTINCT TEMP.ROWID
, ATP.ATP_GROUP_ID
, TEMP.ATP_PERIOD_START_DATE
, TEMP.ATP_PERIOD_END_DATE
, TEMP.ATP_PERIOD_TOTAL_SUPPLY
, TEMP.ATP_PERIOD_TOTAL_DEMAND
, TEMP.PERIOD_NET_AVAILABLE
, TEMP.ATP
, ATP.ENTITY_ID
, DECODE(SIGN(ATP.ENTITY_ID)
, 1
, ITEM2.CONCATENATED_SEGMENTS
, DECODE(ATP.LINE_ID
, NULL
, ATP.DEPARTMENT_CODE || NVL(FND_PROFILE.VALUE( 'BOM:CONFIG_ITEM_DELIMITER')
, '/') || ATP.RESOURCE_CODE
, ATP.LINE_CODE))
, ATP.ORGANIZATION_ID
, P.ORGANIZATION_CODE
, ATP.REQUEST_ITEM_ID
, ITEM1.CONCATENATED_SEGMENTS
, ATP.INVENTORY_ITEM_ID
, ITEM2.CONCATENATED_SEGMENTS
, ATP.RESOURCE_ID
, ATP.RESOURCE_CODE
, ATP.DEPARTMENT_ID
, ATP.DEPARTMENT_CODE
, ATP.LINE_ID
, ATP.LINE_CODE
, ATP.UOM_CODE
, ATP.GROUP_AVAILABLE_DATE
FROM MTL_PARAMETERS P
, MTL_SYSTEM_ITEMS_KFV ITEM2
, MTL_SYSTEM_ITEMS_KFV ITEM1
, MTL_SUPPLY_DEMAND_TEMP TEMP
, MRP_ATP_BASE_V ATP
WHERE TEMP.SEQ_NUM = ATP.ATP_GROUP_ID
AND TEMP.INVENTORY_ITEM_ID = ATP.ENTITY_ID
AND TEMP.ORGANIZATION_ID = ATP.ORGANIZATION_ID
AND TEMP.RECORD_TYPE = 'ATP'
AND P.ORGANIZATION_ID = ATP.ORGANIZATION_ID
AND ITEM1.INVENTORY_ITEM_ID = ATP.REQUEST_ITEM_ID
AND ITEM1.ORGANIZATION_ID = ATP.ORGANIZATION_ID
AND ITEM2.INVENTORY_ITEM_ID = ATP.INVENTORY_ITEM_ID
AND ITEM2.ORGANIZATION_ID = ATP.ORGANIZATION_ID