DBA Data[Home] [Help]

APPS.WPS_SUPPLY_DEMAND dependencies on WIP_FLOW_SCHEDULES

Line 973: WIP_FLOW_SCHEDULES D,

969: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
970: V.INVENTORY_ITEM_ID inventory_item_id,
971: V.ORGANIZATION_ID organization_id
972: FROM
973: WIP_FLOW_SCHEDULES D,
974: BOM_CALENDAR_DATES C,
975: MTL_PARAMETERS P,
976: MTL_SYSTEM_ITEMS I,
977: MTL_ATP_RULES R,

Line 1340: FROM WIP_FLOW_SCHEDULES F,

1336: LEAST(-1*(F.PLANNED_QUANTITY-F.QUANTITY_COMPLETED)*EXTENDED_QUANTITY, 0) supply_demand_quantity,
1337: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1338: V.INVENTORY_ITEM_ID inventory_item_id,
1339: V.ORGANIZATION_ID organization_id
1340: FROM WIP_FLOW_SCHEDULES F,
1341: BOM_BILL_OF_MATERIALS BOM ,
1342: BOM_EXPLOSIONS BE ,
1343: BOM_CALENDAR_DATES C,
1344: MTL_PARAMETERS P,