APPS.CSD_PROCESS_UTIL dependencies on CSD_REPAIRS

Line 517: from csd_repairs

513:
514: select
515: incident_id
516: into x_incident_id
517: from csd_repairs
518: where repair_line_id = p_repair_line_id
519: and ((date_closed is null) OR (date_closed > sysdate));
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN

Line 845: FROM csd_repairs cr,

841: cr.unit_number,
842: crt.third_rma_txn_billing_type_id,
843: crt.third_ship_txn_billing_type_id,
844: crt.third_party_flag
845: FROM csd_repairs cr,
846: csd_repair_types_vl crt
847: where cr.repair_type_id = crt.repair_type_id
848: and cr.repair_line_id = p_rep_line_id;
849:

Line 3571: FROM csd_repairs

3567: SELECT
3568: quantity,
3569: customer_product_id,
3570: serial_number
3571: FROM csd_repairs
3572: where repair_line_id = p_rep_line_id;
3573: BEGIN
3574:
3575: FOR l_srl_num_rec in cur_srl_num_dtls(p_Repair_line_id) LOOP

Line 3601: from csd_repairs

3597: BEGIN
3598:
3599: select 'X'
3600: into l_dummy
3601: from csd_repairs
3602: where repair_line_id = p_repair_line_id;
3603: --bug#6681781, this is not valid validation for repair line id, don't need the last condition
3604: -- and ((date_closed is null) or (trunc(date_closed) >= trunc(sysdate)));
3605:

Line 3731: from csd_repairs a,

3727: BEGIN
3728:
3729: select b.org_id
3730: into l_org_id
3731: from csd_repairs a,
3732: cs_incidents_all_b b
3733: where a.incident_id = b.incident_id
3734: and a.repair_line_id = p_repair_line_id;
3735:

Line 3896: from csd_repairs r,

3892: */
3893:
3894: select t.business_process_id
3895: into l_bus_process_id
3896: from csd_repairs r,
3897: csd_repair_types_b t
3898: where r.repair_line_id = p_repair_line_id
3899: and r.repair_type_id = t.repair_type_id;
3900:

Line 4095: from csd_repairs

4091: BEGIN
4092:
4093: Select count(*)
4094: into l_rejected_quantity
4095: from csd_repairs
4096: where upper(approval_status) = 'R'
4097: and repair_group_id = p_repair_group_id;
4098:
4099: RETURN l_rejected_quantity;

Line 4148: FROM csd_repairs a,

4144: a.repair_mode,
4145: a.repair_type_id,
4146: b.repair_line_id,
4147: c.quantity_required
4148: FROM csd_repairs a,
4149: csd_product_transactions b,
4150: cs_estimate_details c
4151: where a.repair_line_id = b.repair_line_id
4152: and b.estimate_detail_id = c.estimate_detail_id

Line 4181: FROM csd_repairs a,

4177: INTO l_repair_mode,
4178: l_repair_type_id,
4179: l_repair_line_id,
4180: l_prod_txn_qty
4181: FROM csd_repairs a,
4182: csd_product_transactions b,
4183: cs_estimate_details c
4184: where a.repair_line_id = b.repair_line_id
4185: and b.estimate_detail_id = c.estimate_detail_id

Line 4308: FROM csd_repairs

4304:
4305: CURSOR repair_qty IS
4306: SELECT
4307: quantity
4308: FROM csd_repairs
4309: WHERE repair_line_id = p_repair_line_id;
4310:
4311: l_qty_by_type NUMBER := NULL;
4312: l_repair_qty NUMBER := NULL;

Line 4473: FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type

4469: BEGIN
4470: RETURN l_sr_rec;
4471: END sr_rec;
4472:
4473: FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type
4474: IS
4475: l_ro_rec csd_repairs_pub.repln_rec_type;
4476: BEGIN
4477: RETURN l_ro_rec;

Line 4475: l_ro_rec csd_repairs_pub.repln_rec_type;

4471: END sr_rec;
4472:
4473: FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type
4474: IS
4475: l_ro_rec csd_repairs_pub.repln_rec_type;
4476: BEGIN
4477: RETURN l_ro_rec;
4478: END repair_order_rec;
4479:

Line 5774: from csd_repairs dr,

5770: If(p_Action_type = 'RMA') then
5771: begin
5772: Select max(ced.order_header_id)
5773: into l_add_to_order_id
5774: from csd_repairs dr,
5775: cs_estimate_details ced,
5776: oe_order_headers_all ooh,
5777: oe_order_types_v oot,
5778: cs_incidents_all_b sr -- swai: bug 5931926

Line 5809: from csd_repairs dr,

5805: begin
5806:
5807: Select max(ced.order_header_id)
5808: into l_add_to_order_id
5809: from csd_repairs dr,
5810: cs_estimate_details ced,
5811: oe_order_headers_all ooh,
5812: oe_order_types_v oot,
5813: cs_incidents_all_b sr -- swai: bug 5931926