DBA Data[Home] [Help]

APPS.WIP_MRP_RELIEF dependencies on WIP_REQUIREMENT_OPERATIONS

Line 151: FROM WIP_REQUIREMENT_OPERATIONS

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

Line 307: FROM wip_requirement_operations

303: new_project_id,
304: old_project_id,
305: new_task_id,
306: old_task_id
307: FROM wip_requirement_operations
308: WHERE wip_entity_id = wip_enty_id
309: AND organization_id = org_id
310: AND wip_supply_type = 6;
311: ELSE /** INSERTING or UPDATING **/

Line 376: FROM wip_requirement_operations

372: new_project_id,
373: old_project_id,
374: new_task_id,
375: old_task_id
376: FROM wip_requirement_operations
377: WHERE wip_entity_id = wip_enty_id
378: AND organization_id = org_id
379: AND wip_supply_type = 6;
380: END IF;