[Home] [Help]
981:
982: -- Cursor to get Party site use id
983: Cursor c_get_party_site_use_id (p_incident_id number )is
984: Select ship_to_site_use_id
985: from cs_incidents_all_b
986: where incident_id = p_incident_id;
987:
988: -- Cursor to derive Primary UOM code
989: Cursor c_get_item_uom_code (p_inventory_item_id number) is
1809: cpt.lot_number
1810: -- end 12.2 changes, subhat
1811: from
1812: csd_product_txns_v cpt,
1813: cs_incidents_all_b cib,
1814: csd_repairs cr,
1815: mtl_system_items_kfv mtl
1816: where cpt.repair_line_id = p_repair_line_id
1817: and cr.repair_line_id = cpt.repair_line_id
2318:
2319: -- Cursor to get Incident number
2320: Cursor c_get_sr_details(p_incident_id in number) is
2321: Select incident_number
2322: from cs_incidents_all_b
2323: where incident_id = p_incident_id;
2324:
2325: -- Cursor to get Repair Order number
2326: Cursor c_get_ro_details(p_repair_line_id in number) is
2623: l_no_exact_match varchar2(3) := 'N';
2624:
2625:
2626: lc_sql_string_ro varchar2(2000) :=' select sr.incident_id,cr.repair_line_id,cr.quantity,''N'',''N''' ||
2627: ' from cs_incidents_all_b sr,csd_repairs cr,csd_repair_types_b crt '||
2628: ' where cr.inventory_item_id = :p_inv_item_id '||
2629: ' and cr.status = ''O'' '||
2630: ' and cr.incident_id = sr.incident_id '||
2631: ' and sr.account_id = :p_acc_id '||
2783: into x_sr_ro_rma_tbl(l_counter).incident_id,x_sr_ro_rma_tbl(l_counter).repair_line_id,
2784: x_sr_ro_rma_tbl(l_counter).create_sr_flag,x_sr_ro_rma_tbl(l_counter).create_ro_flag
2785: from (
2786: select sr.incident_id,cr.repair_line_id,'N' create_sr_flag,'N' create_ro_flag
2787: from csd_repairs cr,cs_incidents_all_b sr
2788: where cr.inventory_item_id = x_sr_ro_rma_tbl(l_counter).inventory_item_id
2789: and cr.status = 'O'
2790: and cr.incident_id = sr.incident_id
2791: and sr.account_id = x_sr_ro_rma_tbl(l_counter).cust_acct_id
2834: x_sr_ro_rma_tbl(l_counter).create_sr_flag,
2835: x_sr_ro_rma_tbl(l_counter).create_ro_flag
2836: from csd_repairs cr,
2837: csd_product_transactions cpt,
2838: cs_incidents_all_b sr,
2839: cs_estimate_details ced
2840: where cr.incident_id = sr.incident_id
2841: and sr.account_id = x_sr_ro_rma_tbl(l_counter).cust_acct_id
2842: and sr.customer_id = x_sr_ro_rma_tbl(l_counter).party_id
2881: into x_sr_ro_rma_tbl(l_counter).incident_id,x_sr_ro_rma_tbl(l_counter).repair_line_id,
2882: x_sr_ro_rma_tbl(l_counter).create_sr_flag,x_sr_ro_rma_tbl(l_counter).create_ro_flag
2883: from(
2884: select sr.incident_id,cr.repair_line_id,'N' create_sr_flag,'N' create_ro_flag
2885: from csd_repairs cr,cs_incidents_all_b sr
2886: where cr.inventory_item_id = x_sr_ro_rma_tbl(l_counter).inventory_item_id
2887: and cr.status = 'O'
2888: and cr.incident_id = sr.incident_id
2889: and sr.account_id = x_sr_ro_rma_tbl(l_counter).cust_acct_id
2933: x_sr_ro_rma_tbl(l_counter).create_sr_flag,
2934: x_sr_ro_rma_tbl(l_counter).create_ro_flag
2935: FROM csd_repairs cr,
2936: csd_product_transactions cpt,
2937: cs_incidents_all_b sr
2938: WHERE cr.incident_id = sr.incident_id
2939: AND sr.account_id = x_sr_ro_rma_tbl(l_counter).cust_acct_id
2940: AND sr.customer_id = x_sr_ro_rma_tbl(l_counter).party_id
2941: AND cpt.repair_line_id = cr.repair_line_id
3522: cpt.revision,
3523: cpt.lot_number
3524: from
3525: csd_product_txns_v cpt,
3526: cs_incidents_all_b cib,
3527: csd_repairs cr,
3528: mtl_system_items_kfv mtl
3529: where cpt.repair_line_id = p_repair_line_id
3530: and cr.repair_line_id = cpt.repair_line_id
4048: from csd_product_transactions cpt,
4049: cs_estimate_details ced,
4050: oe_order_headers_all ooh,
4051: oe_order_types_v oot,
4052: cs_incidents_all_b sr
4053: where cpt.estimate_detail_id = ced.estimate_detail_id
4054: and cpt.repair_line_id = p_repair_line_id
4055: and ced.order_header_id is not null
4056: and ced.interface_to_oe_flag = 'Y'
4290: select incident_id
4291: into l_incident_id
4292: from (
4293: select incident_id
4294: from cs_incidents_all_b
4295: where customer_id = p_party_id
4296: and account_id = p_account_id
4297: and status_flag = 'O'
4298: order by incident_id desc