VIEW: APPS.MRP_ATP_PERIOD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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