APPS.CSD_REPAIRS_UTIL dependencies on CSD_REPAIR_JOB_XREF

Line 751: FROM csd_repair_job_xref crx, wip_discrete_jobs wdj

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

Line 758: FROM csd_repair_job_xref

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

Line 2898: csd_repair_job_xref crj,csd_wip_transaction_details cwt

2894: -- SELECT all the requisition id's originated from CSD and are not yet interfaced to OM.
2895: SELECT prh.requisition_header_id
2896: BULK COLLECT INTO l_requisition_id
2897: FROM po_requisition_headers_all prh,po_requisition_lines_all prl,
2898: csd_repair_job_xref crj,csd_wip_transaction_details cwt
2899: WHERE crj.wip_entity_id = cwt.wip_entity_id
2900: AND cwt.wip_entity_id = prl.wip_entity_id
2901: AND cwt.inventory_item_id = prl.item_id
2902: AND cwt.operation_seq_num = prl.wip_operation_seq_num

Line 3057: csd_repair_job_xref crj, wip_discrete_jobs wdj

3053: CURSOR c_all_mtl_transactions(p_repair_line_id NUMBER)
3054: IS
3055: SELECT mmt.reason_id,mmt.inventory_item_id,wdj.primary_item_id,wro.organization_id
3056: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
3057: csd_repair_job_xref crj, wip_discrete_jobs wdj
3058: WHERE crj.repair_line_id = p_repair_line_id
3059: AND crj.wip_entity_id = wro.wip_entity_id
3060: AND wro.operation_seq_num = mmt.operation_seq_num
3061: AND wro.organization_id = mmt.organization_id