APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on CSD_REPAIRS

Line 578: CSD_REPAIRS RO

574: -- from the RO currency.
575: CURSOR c_multi_currency_check IS
576: SELECT count(distinct CEST.currency_code)
577: FROM CS_ESTIMATE_DETAILS CEST,
578: CSD_REPAIRS RO
579: WHERE RO.repair_line_id = p_repair_line_id
580: AND CEST.original_source_code = 'DR'
581: AND CEST.original_source_id = RO.repair_line_id
582: AND CEST.source_code = 'SD'

Line 1212: l_default_po_number csd_repairs.default_po_num%type;

1208: /*Fixed for bug#5846031
1209: po number from RO should be defaulted on actual lines
1210: created from WIP.
1211: */
1212: l_default_po_number csd_repairs.default_po_num%type;
1213:
1214: -- swai: bug 7119691
1215: l_bill_to_account_id NUMBER;
1216: l_bill_to_party_id NUMBER;

Line 2069: from csd_repairs

2065: */
2066: begin
2067: select default_po_num
2068: into l_default_po_number
2069: from csd_repairs
2070: where repair_line_id = p_repair_line_id;
2071: exception
2072: when no_data_found then
2073: l_default_po_number := Null;

Line 2575: CSD_REPAIRS CR, -- swai: bug 4618500 (FP of 4580845)

2571: ESTL.attribute14,
2572: ESTL.attribute15,
2573: ESTL.override_charge_flag
2574: FROM CSD_REPAIR_ESTIMATE ESTH,
2575: CSD_REPAIRS CR, -- swai: bug 4618500 (FP of 4580845)
2576: CSD_REPAIR_ESTIMATE_LINES ESTL
2577: -- swai: bug 4618500 (FP of 4580845)
2578: -- Join with table CSD_REPAIRS added
2579: -- We should not import the line from estimate to Actuals until the lines are accepted (i.e. approved)

Line 2578: -- Join with table CSD_REPAIRS added

2574: FROM CSD_REPAIR_ESTIMATE ESTH,
2575: CSD_REPAIRS CR, -- swai: bug 4618500 (FP of 4580845)
2576: CSD_REPAIR_ESTIMATE_LINES ESTL
2577: -- swai: bug 4618500 (FP of 4580845)
2578: -- Join with table CSD_REPAIRS added
2579: -- We should not import the line from estimate to Actuals until the lines are accepted (i.e. approved)
2580: -- if the flag Estimate Approval Required flag is checked. (This would make the behavior consistent with 1159)
2581: -- Modified the query to achieve following:
2582: -- (1)If Estimate Approval Required flag is checked and status of the estimate is accepted then only

Line 3208: csd_repairs csd

3204: act.bill_to_party_id,
3205: act.bill_to_party_site_id,
3206: csd.incident_id
3207: from csd_repair_actuals act,
3208: csd_repairs csd
3209: where csd.repair_line_id = p_repair_line_id
3210: and act.repair_line_id = csd.repair_line_id;
3211:
3212: CURSOR c_sr_bill_to_ship_to(p_repair_line_id NUMBER)

Line 3218: from csd_repairs csd,

3214: select cs.account_id,
3215: cs.bill_to_party_id,
3216: cs.bill_to_site_id,
3217: cs.ship_to_site_id
3218: from csd_repairs csd,
3219: cs_incidents_all_b cs
3220: where csd.repair_line_id = p_repair_line_id
3221: and csd.incident_id = cs.incident_id;
3222: