APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSD_REPAIRS

Line 30: FROM csd_repairs cr

26: -- gilam: changed the EXISTS query part so that the lines are not getting from
27: -- csd_repair_estimate_lines_v since the view only has lines of
28: -- charge line type = ESTIMATE, but we want lines that have type ACTUAL
29: SELECT distinct cr.repair_line_id repair_line_id
30: FROM csd_repairs cr
31: , csd_repair_estimate cre
32: WHERE cr.repair_line_id = cre.repair_line_id
33: AND EXISTS ( SELECT 'x'
34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced

Line 49: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',

45: -- Get the Slab Number for the table
46:
47: BEGIN
48:
49: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',
50: 'CSD',
51: p_slab_number,
52: v_min,
53: v_max);

Line 190: , csd_repairs cr

186: CURSOR get_est_lines(p_start_rep_line_id number, p_end_rep_line_id number)
187: IS
188: SELECT ced.estimate_detail_id
189: FROM cs_estimate_details ced
190: , csd_repairs cr
191: , csd_repair_estimate cre
192: , csd_repair_estimate_lines crel
193: WHERE cr.repair_line_id = cre.repair_line_id
194: AND cre.repair_estimate_id = crel.repair_estimate_id

Line 213: -- gilam: bug 3410383 - changed slab table to csd_repairs

209: -- Get the Slab Number for the table
210:
211: BEGIN
212:
213: -- gilam: bug 3410383 - changed slab table to csd_repairs
214: /*
215: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',
216: 'CSD',
217: p_slab_number,

Line 222: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',

218: v_min,
219: v_max);
220: */
221:
222: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',
223: 'CSD',
224: p_slab_number,
225: v_min,
226: v_max);

Line 333: FROM csd_repairs cr

329:
330: CURSOR get_rep_est_lines(p_start_rep_line_id number, p_end_rep_line_id number)
331: IS
332: SELECT crel.repair_estimate_line_id
333: FROM csd_repairs cr
334: , csd_repair_estimate cre
335: , csd_repair_estimate_lines crel
336: WHERE cr.repair_line_id = cre.repair_line_id
337: AND cre.repair_estimate_id = crel.repair_estimate_id

Line 349: -- gilam: bug 3410383 - changed slab table to csd_repairs

345: -- Get the Slab Number for the table
346:
347: BEGIN
348:
349: -- gilam: bug 3410383 - changed slab table to csd_repairs
350: /*
351: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_ESTIMATE_LINES',
352: 'CSD',
353: p_slab_number,

Line 358: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',

354: v_min,
355: v_max);
356: */
357:
358: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',
359: 'CSD',
360: p_slab_number,
361: v_min,
362: v_max);

Line 1193: , csd_repairs cr

1189: ,ced.rate_type_code
1190: --sangigup
1191:
1192: FROM cs_estimate_details ced
1193: , csd_repairs cr
1194: , csd_repair_estimate cre
1195: , csd_repair_estimate_lines crel
1196: WHERE cr.repair_line_id = cre.repair_line_id
1197: AND cre.repair_estimate_id = crel.repair_estimate_id

Line 1216: -- gilam: bug 3410383 - changed slab table to csd_repairs

1212: -- Get the Slab Number for the table
1213:
1214: BEGIN
1215:
1216: -- gilam: bug 3410383 - changed slab table to csd_repairs
1217: /*
1218: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',
1219: 'CSD',
1220: p_slab_number,

Line 1225: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',

1221: v_min,
1222: v_max);
1223: */
1224:
1225: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',
1226: 'CSD',
1227: p_slab_number,
1228: v_min,
1229: v_max);

Line 3378: csd_repairs cr ,

3374: NULL, -- Quantity_shipped
3375: NULL, -- source_serial_number
3376: NULL -- non_source_serial_number
3377: From csd_product_transactions cpt ,
3378: csd_repairs cr ,
3379: csd_repair_types_b crt,
3380: cs_estimate_details ced ,
3381: oe_order_headers_all ooha,
3382: oe_order_lines_all oola ,

Line 3611: -- csd_repairs table, if the record is not found there too then Depot will assign

3607: -- successfully received in inventory. In such cases there will be no record created
3608: -- in rcv_transactions table.So Depot has changed the logic for finding
3609: -- serial number for recevied items, it looks for serial number information in
3610: -- rcv_transactions table but if the record does not exist it looks for the info in
3611: -- csd_repairs table, if the record is not found there too then Depot will assign
3612: -- blank values to source serial number column.
3613: -- This strategy will help upgrade process not to stop because of missing records in
3614: -- rcv_transactions table.
3615: -- Item is serial controlled

Line 3630: -- look for serial number information in csd_repairs table,

3626: and rownum = 1;
3627: Exception
3628: When No_Data_Found Then
3629: -- To fix bug 3842957/4140451 saupadhy
3630: -- look for serial number information in csd_repairs table,
3631: -- As this case will arise only for pre 11i transactions and in pre 11i
3632: -- Depot creates RO only after an item is received, if the item is serial
3633: -- controlled, Depot captures serial number information in csd_repairs table.
3634: V_Quantity_Received(j) := 1;

Line 3633: -- controlled, Depot captures serial number information in csd_repairs table.

3629: -- To fix bug 3842957/4140451 saupadhy
3630: -- look for serial number information in csd_repairs table,
3631: -- As this case will arise only for pre 11i transactions and in pre 11i
3632: -- Depot creates RO only after an item is received, if the item is serial
3633: -- controlled, Depot captures serial number information in csd_repairs table.
3634: V_Quantity_Received(j) := 1;
3635: v_Locator_ID(j) := Null;
3636: Begin
3637: Select Serial_Number Into V_Source_Serial_Number(j)

Line 3638: From CSD_Repairs

3634: V_Quantity_Received(j) := 1;
3635: v_Locator_ID(j) := Null;
3636: Begin
3637: Select Serial_Number Into V_Source_Serial_Number(j)
3638: From CSD_Repairs
3639: Where Repair_line_Id = V_Repair_Line_ID(j);
3640: Exception
3641: When No_Data_Found THen
3642: -- Assign Null value to Serial Number array and move on.