APPS.CSD_LOGISTICS_PVT dependencies on CSD_REPAIRS

Line 146: l_ro_Status CSD_REPAIRS.Status%type;

142: -- Define Local Variables
143: l_RO_Status_Meaning VARCHAR2(80);
144: l_RO_NUMBER VARCHAR2(30);
145: l_Order_Header_ID Number;
146: l_ro_Status CSD_REPAIRS.Status%type;
147:
148: -- Define a record of type
149: l_Product_Txn_Rec CSD_PROCESS_PVT.Product_Txn_Rec;
150:

Line 193: FROM CSD_Product_Txns_v A, CSD_REPAIRS B

189: A.Contract_Line_Id,
190: A.Business_Process_id,
191: B.incident_id,
192: A.Reference_Number
193: FROM CSD_Product_Txns_v A, CSD_REPAIRS B
194: WHERE A.REPAIR_LINE_ID = B.REPAIR_LINE_ID
195: AND Product_Transaction_Id =
196: p_Upd_ProdTxn_Rec.Product_Transaction_Id;
197:

Line 202: FROM Csd_Repairs dra, fnd_lookups fndl2

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