DBA Data[Home] [Help]

APPS.INV_MO_PURGE dependencies on WIP_DISCRETE_JOBS

Line 297: from wip_discrete_jobs

293: IF (l_entity_type in (3,7,8)) THEN
294: Begin
295: select 0
296: into can_delete
297: from wip_discrete_jobs
298: where wip_entity_id = mo_line.txn_source_id
299: and organization_id = mo_line.organization_id
300: and status_type <> 12;
301: Exception

Line 347: FROM wip_discrete_jobs

343: ELSIF (l_entity_type = 6) THEN --bug12767095 purge EAM work order
344: BEGIN
345: SELECT 0
346: INTO can_delete
347: FROM wip_discrete_jobs
348: WHERE wip_entity_id = mo_line.txn_source_id
349: AND organization_id = mo_line.organization_id
350: AND status_type not in (12,7);--closed or cancelled
351: Exception