DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_PVT dependencies on FND_LOOKUPS

Line 206: FROM Csd_Repairs dra, fnd_lookups fndl2

202: -- Define a cursor that gets Repair NUMBER AND Repair Status meaning for a given
203: -- repair line id
204: CURSOR RepairStatus_Cur_Type(p_Repair_Line_Id IN NUMBER) IS
205: SELECT dra.Repair_NUMBER, fndl2.meaning Status_Meaning
206: FROM Csd_Repairs dra, fnd_lookups fndl2
207: WHERE dra.status = fndl2.lookup_code
208: and fndl2.lookup_type = 'CSD_REPAIR_STATUS'
209: and dra.repair_line_id = p_Repair_line_id;
210: