APPS.FLM_SUPPLY_DEMAND dependencies on MTL_SECONDARY_INVENTORIES

Line 360: MTL_SECONDARY_INVENTORIES S,

356: TO_NUMBER(TO_CHAR(C.NEXT_DATE-1,'J')) supply_demand_date,
357: V.INVENTORY_ITEM_ID inventory_item_id,
358: V.ORGANIZATION_ID organization_id
359: FROM
360: MTL_SECONDARY_INVENTORIES S,
361: BOM_CALENDAR_DATES C,
362: MTL_PARAMETERS P,
363: MTL_ONHAND_QUANTITIES Q,
364: MTL_ATP_RULES R,

Line 396: FROM MTL_SECONDARY_INVENTORIES S,

392: SUM(T.PRIMARY_QUANTITY) supply_demand_quantity,
393: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
394: V.INVENTORY_ITEM_ID inventory_item_id,
395: V.ORGANIZATION_ID organization_id
396: FROM MTL_SECONDARY_INVENTORIES S,
397: BOM_CALENDAR_DATES C,
398: MTL_PARAMETERS P,
399: MTL_MATERIAL_TRANSACTIONS_TEMP T,
400: MTL_SYSTEM_ITEMS I,

Line 603: 'X' FROM MTL_SECONDARY_INVENTORIES S2

599: AND S.TO_ORGANIZATION_ID=V.ORGANIZATION_ID
600: AND S.ITEM_ID = V.INVENTORY_ITEM_ID
601: AND S.DESTINATION_TYPE_CODE='INVENTORY'
602: AND (S.TO_SUBINVENTORY IS NULL OR EXISTS (SELECT
603: 'X' FROM MTL_SECONDARY_INVENTORIES S2
604: WHERE S2.ORGANIZATION_ID=S.TO_ORGANIZATION_ID
605: AND S.TO_SUBINVENTORY=S2.SECONDARY_INVENTORY_NAME
606: AND S2.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
607: 1, 1,

Line 1470: FROM MTL_SECONDARY_INVENTORIES S

1466: AND D.DEMAND_SOURCE_TYPE <> DECODE(R.INCLUDE_SALES_ORDERS, 2, 2, -1)
1467: AND D.DEMAND_SOURCE_TYPE <> DECODE(R.INCLUDE_INTERNAL_ORDERS, 2, 8, -1)
1468: AND (D.SUBINVENTORY IS NULL
1469: OR D.SUBINVENTORY IN (SELECT S.SECONDARY_INVENTORY_NAME
1470: FROM MTL_SECONDARY_INVENTORIES S
1471: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
1472: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES, 1, 1, NULL, 1, S.INVENTORY_ATP_CODE)
1473: AND S.AVAILABILITY_TYPE =DECODE(R.DEFAULT_ATP_SOURCES, 2, 1, S.AVAILABILITY_TYPE)))
1474: AND V.AVAILABLE_TO_ATP = 1