APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSD_FLOW_STATUSES_B

Line 601: csd_flow_statuses_b cfs

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
604: AND cr.repair_line_id = p_repair_line_id
605: AND cr.repair_type_id = nvl(cat.repair_type_id,cr.repair_type_id)

Line 653: csd_flow_statuses_b cfs

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 (
656: select mic.inventory_item_id
657: from mtl_item_categories mic