APPS.WIP_MRP_RELIEF dependencies on WIP_REQUIREMENT_OPERATIONS

Line 148: FROM WIP_REQUIREMENT_OPERATIONS

144: | must actually check and see if any requirements were changed. |
145: +-----------------------------------------------------------------+*/
146: SELECT COUNT(*)
147: INTO wip_req_ops_rows
148: FROM WIP_REQUIREMENT_OPERATIONS
149: WHERE WIP_ENTITY_ID = wip_enty_id
150: AND ORGANIZATION_ID = org_id
151: AND (NVL(MPS_REQUIRED_QUANTITY,required_quantity+1) <>
152: required_quantity

Line 303: FROM wip_requirement_operations

299: new_project_id,
300: old_project_id,
301: new_task_id,
302: old_task_id
303: FROM wip_requirement_operations
304: WHERE wip_entity_id = wip_enty_id
305: AND organization_id = org_id
306: AND wip_supply_type = 6;
307: ELSE /** INSERTING or UPDATING **/

Line 372: FROM wip_requirement_operations

368: new_project_id,
369: old_project_id,
370: new_task_id,
371: old_task_id
372: FROM wip_requirement_operations
373: WHERE wip_entity_id = wip_enty_id
374: AND organization_id = org_id
375: AND wip_supply_type = 6;
376: END IF;