DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on WIP_OSP_JOBS_VAL_V

Line 1927: from wip_osp_jobs_val_v job, pa_tasks task

1923: and we.entity_type = 6
1924: and wdj.status_type in (3,4,6);
1925: else
1926: select count(*) into x_count
1927: from wip_osp_jobs_val_v job, pa_tasks task
1928: where job.wip_entity_id = x_wip_entity_id
1929: and job.organization_id = x_destination_organization_id
1930: and task.task_id (+) = job.task_id;
1931: end if;