APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSD_REPAIR_HISTORY

Line 599: (select * from csd_repair_history

595: SELECT to_number('1')
596: into l_aging_threshold
597: FROM csd_aging_thresholds_b cat,
598: csd_repairs cr ,
599: (select * from csd_repair_history
600: where repair_line_id = p_repair_line_id and event_code = 'SC') crh ,
601: csd_flow_statuses_b cfs
602: WHERE cat.inventory_item_id = p_inventory_item_id
603: AND cat.inventory_org_id = p_organization_id

Line 622: FROM csd_repair_history crh1

618: WHERE repair_line_id = cr.repair_line_id
619: AND flow_status_id = cat.flow_status_id -- bug#8972971, subhat
620: ),
621: (SELECT SYSDATE - crh1.creation_date
622: FROM csd_repair_history crh1
623: WHERE crh1.repair_line_id = crh.repair_line_id
624: AND crh1.paramc1 = crh.paramc1
625: AND rownum = 1
626: ) ) ) > cat.threshold_days ;

Line 651: (select * from csd_repair_history

647: SELECT to_number('1')
648: INTO l_aging_threshold
649: FROM csd_aging_thresholds_b cat,
650: csd_repairs cr ,
651: (select * from csd_repair_history
652: where repair_line_id = p_repair_line_id and event_code = 'SC') crh,
653: csd_flow_statuses_b cfs
654: WHERE cat.inventory_org_id = p_organization_id
655: AND p_inventory_item_id in (

Line 680: FROM csd_repair_history crh1

676: WHERE repair_line_id = cr.repair_line_id
677: AND flow_status_id = cat.flow_status_id -- bug#8972971, subhat
678: ),
679: (SELECT SYSDATE - crh1.creation_date
680: FROM csd_repair_history crh1
681: WHERE crh1.repair_line_id = crh.repair_line_id
682: AND crh1.paramc1 = crh.paramc1
683: AND rownum = 1
684: ) ) ) > cat.threshold_days ;