[Home] [Help]
362: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
363: V.INVENTORY_ITEM_ID inventory_item_id,
364: V.ORGANIZATION_ID organization_id
365: FROM
366: MTL_SECONDARY_INVENTORIES S,
367: BOM_CALENDAR_DATES C,
368: MTL_PARAMETERS P,
369: MTL_ONHAND_QUANTITIES Q,
370: MTL_ATP_RULES R,
398: SUM(T.PRIMARY_QUANTITY) supply_demand_quantity,
399: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
400: V.INVENTORY_ITEM_ID inventory_item_id,
401: V.ORGANIZATION_ID organization_id
402: FROM MTL_SECONDARY_INVENTORIES S,
403: BOM_CALENDAR_DATES C,
404: MTL_PARAMETERS P,
405: MTL_MATERIAL_TRANSACTIONS_TEMP T,
406: MTL_SYSTEM_ITEMS I,
605: AND S.TO_ORGANIZATION_ID=V.ORGANIZATION_ID
606: AND S.ITEM_ID = V.INVENTORY_ITEM_ID
607: AND S.DESTINATION_TYPE_CODE='INVENTORY'
608: AND (S.TO_SUBINVENTORY IS NULL OR EXISTS (SELECT
609: 'X' FROM MTL_SECONDARY_INVENTORIES S2
610: WHERE S2.ORGANIZATION_ID=S.TO_ORGANIZATION_ID
611: AND S.TO_SUBINVENTORY=S2.SECONDARY_INVENTORY_NAME
612: AND S2.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
613: 1, 1,
1457: AND D.DEMAND_SOURCE_TYPE <> DECODE(R.INCLUDE_SALES_ORDERS, 2, 2, -1)
1458: AND D.DEMAND_SOURCE_TYPE <> DECODE(R.INCLUDE_INTERNAL_ORDERS, 2, 8, -1)
1459: AND (D.SUBINVENTORY IS NULL
1460: OR D.SUBINVENTORY IN (SELECT S.SECONDARY_INVENTORY_NAME
1461: FROM MTL_SECONDARY_INVENTORIES S
1462: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
1463: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES, 1, 1, NULL, 1, S.INVENTORY_ATP_CODE)
1464: AND S.AVAILABILITY_TYPE =DECODE(R.DEFAULT_ATP_SOURCES, 2, 1, S.AVAILABILITY_TYPE)))
1465: AND V.AVAILABLE_TO_ATP = 1