DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on WIP_OSP_JOBS_VAL_V

Line 1782: from wip_osp_jobs_val_v job, pa_tasks task

1778: and we.entity_type = 6
1779: and wdj.status_type in (3,4,6);
1780: else
1781: select count(*) into x_count
1782: from wip_osp_jobs_val_v job, pa_tasks task
1783: where job.wip_entity_id = x_wip_entity_id
1784: and job.organization_id = x_destination_organization_id
1785: and task.task_id (+) = job.task_id;
1786: end if;