DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSD_REPAIR_TYPES_VL

Line 161: from csd_repair_types_vl

157: and mtl.organization_id = p_organization_id;
158:
159: CURSOR c_get_repair_type_name (p_repair_type_id NUMBER) IS
160: Select Name
161: from csd_repair_types_vl
162: where repair_type_id = P_Repair_Type_Id;
163: -- end bug#13698799
164:
165: BEGIN

Line 5034: FROM CSD_REPAIR_TYPES_Vl CRTV, CSD_REPAIR_TYPES_Vl CRTV1

5030:
5031: -- Query to derive from and to repair type name
5032: CURSOR c_get_repair_types IS
5033: SELECT CRTV.name name1, CRTV1.name name2
5034: FROM CSD_REPAIR_TYPES_Vl CRTV, CSD_REPAIR_TYPES_Vl CRTV1
5035: WHERE
5036: CRTV.REPAIR_TYPE_Id = p_from_repair_type_id AND
5037: CRTV1.REPAIR_TYPE_Id = p_to_repair_type_id;
5038: