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 197: FROM CSD_Product_Txns_v A, CSD_REPAIRS B

193: B.incident_id,
194: A.Reference_Number,
195: A.picking_rule_id,
196: A.inventory_org_id -- bug#13114174
197: FROM CSD_Product_Txns_v A, CSD_REPAIRS B
198: WHERE A.REPAIR_LINE_ID = B.REPAIR_LINE_ID
199: AND Product_Transaction_Id =
200: p_Upd_ProdTxn_Rec.Product_Transaction_Id;
201:

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: