DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on WIP_DISCRETE_JOBS

Line 749: FROM csd_repair_job_xref crx, wip_discrete_jobs wdj

745:
746: -- Cursor to check open wip jobs for the repair order
747: CURSOR wipjob_cur IS
748: SELECT 'x' /* crx.repair_job_xref_id */
749: FROM csd_repair_job_xref crx, wip_discrete_jobs wdj
750: WHERE crx.repair_line_id = p_repair_line_id
751: AND crx.wip_entity_id = wdj.wip_entity_id
752: AND wdj.status_type NOT IN (4,5,7,12)
753: /* 4: Complete,5: Complete-No charges,7: Cancelled,12: Closed */