eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WPS_SUPPLY_DEMAND dependencies on WIP_DISCRETE_JOBS

Line 693: FROM WIP_DISCRETE_JOBS D,

689: D.START_QUANTITY - D.QUANTITY_COMPLETED - D.QUANTITY_SCRAPPED) supply_demand_quantity,
690: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
691: V.INVENTORY_ITEM_ID inventory_item_id,
692: V.ORGANIZATION_ID organization_id
693: FROM WIP_DISCRETE_JOBS D,
694: BOM_CALENDAR_DATES C,
695: MTL_PARAMETERS P,
696: MTL_SYSTEM_ITEMS I,
697: MTL_ATP_RULES R,

Line 787: WIP_DISCRETE_JOBS D

783: MTL_ATP_RULES R,
784: MTL_SYSTEM_ITEMS I,
785: BOM_CALENDAR_DATES C,
786: WIP_REQUIREMENT_OPERATIONS O,
787: WIP_DISCRETE_JOBS D
788: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID
789: AND O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
790: AND O.WIP_ENTITY_ID=D.WIP_ENTITY_ID
791: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 1066: WIP_DISCRETE_JOBS D,

1062: MTL_ATP_RULES R,
1063: MTL_SYSTEM_ITEMS I,
1064: BOM_CALENDAR_DATES C,
1065: WIP_REQUIREMENT_OPERATIONS O,
1066: WIP_DISCRETE_JOBS D,
1067: BOM_CALENDAR_DATES C1
1068: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1069: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID
1070: AND O.WIP_SUPPLY_TYPE <> 6