DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on CSD_REPAIR_JOB_XREF

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 */

Line 756: FROM csd_repair_job_xref

752: AND wdj.status_type NOT IN (4,5,7,12)
753: /* 4: Complete,5: Complete-No charges,7: Cancelled,12: Closed */
754: UNION ALL
755: SELECT 'x' /* repair_job_xref_id*/
756: FROM csd_repair_job_xref
757: WHERE repair_line_id = p_repair_line_id
758: AND wip_entity_id IS NULL;
759:
760: -- Cursor to get the repair mode