[Home] [Help]
84: -- l_Charge_Details_rec.bill_to_account_id,
85: l_Charge_Details_rec.ship_to_party_id,
86: l_Charge_Details_rec.ship_to_account_id,
87: l_Charge_Details_rec.ship_to_org_id
88: FROM cs_estimate_details
89: WHERE source_id = p_repair_line_id
90: AND order_header_id = p_order_header_id
91: AND order_line_id = p_order_line_id;
92: EXCEPTION
102: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
103: 'Under-receipt: before updating order header_id');
104: End if;
105: -- need to fake as if the charges line is not submitted to OM.
106: update cs_estimate_details
107: set order_line_id = null --, order_header_id = null
108: where estimate_detail_id = l_Charge_Details_rec.estimate_detail_id;
109:
110: -- from the create rec, copy the details required for update.
148: raise l_update_charge_err;
149: end if;
150:
151: -- reset the order number and order line values.
152: update cs_estimate_details
153: set order_header_id = p_order_header_id, order_line_id = p_order_line_id
154: where estimate_detail_id = l_Charge_Details_rec.estimate_detail_id;
155:
156: -- Need to create a new charge line and associate it to existing OM line.
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
2843: and cpt.repair_line_id = cr.repair_line_id
3047: ool.inventory_item_id
3048: bulk collect into
3049: l_matching_rma_tbl
3050: from csd_product_transactions cpt,
3051: cs_estimate_details ced,
3052: oe_order_lines_all ool,
3053: csd_repairs cr,
3054: csd_repair_types_b crtb
3055: where
3089: l_prod_txn_rec.organization_id,
3090: l_prod_txn_rec.inventory_org_id
3091:
3092: from csd_product_transactions cpt,
3093: cs_estimate_details ced
3094: where cpt.repair_line_id = p_repair_line_id and
3095: cpt.action_type = 'RMA' and
3096: cpt.action_code in ('CUST_PROD','EXCHANGE') and
3097: cpt.prod_txn_status <> 'RECEIVED' and
3119: ool.inventory_item_id
3120: bulk collect into
3121: l_matching_rma_tbl
3122: from csd_product_transactions cpt,
3123: cs_estimate_details ced,
3124: oe_order_lines_all ool,
3125: csd_repairs cr
3126: where
3127: cpt.repair_line_id = p_repair_line_id and
3138: begin
3139: select 'Y'
3140: into x_rma_found
3141: from csd_product_transactions cpt,
3142: cs_estimate_details ced
3143: where cpt.repair_line_id = p_repair_line_id and
3144: cpt.action_type = 'RMA' and
3145: cpt.action_code = 'LOANER' and
3146: cpt.prod_txn_status <> 'RECEIVED' and
3263: l_prod_txn_rec.business_process_id,l_prod_txn_rec.currency_code,
3264: l_prod_txn_rec.ship_to_party_id,l_prod_txn_rec.ship_to_account_id,
3265: l_prod_txn_rec.return_reason,l_prod_txn_rec.contract_line_id
3266: from csd_product_transactions cpt,
3267: cs_estimate_details ced
3268: where cpt.repair_line_id = p_repair_line_id and
3269: ced.estimate_detail_id = cpt.estimate_detail_id and
3270: cpt.action_type IN ('RMA','RMA_THIRD_PARTY') and
3271: abs(ced.quantity_required) = p_rma_quantity
3309: select ced.order_line_id,
3310: ced.order_header_id
3311: into x_order_line_id,
3312: x_order_header_id
3313: from cs_estimate_details ced,csd_product_transactions cpt
3314: where cpt.product_transaction_id = l_prod_txn_rec.product_transaction_id
3315: and ced.estimate_detail_id = cpt.estimate_detail_id;
3316: exception
3317: when no_data_found then
3598: bulk collect into
3599: l_bulk_autorcv_tbl
3600: from csd_bulk_receive_items_b cbr,
3601: csd_product_transactions cpt,
3602: cs_estimate_details ced
3603: where cbr.transaction_number = p_transaction_number
3604: and cbr.repair_line_id = cpt.repair_line_id
3605: and cpt.action_type = 'RMA'
3606: and cpt.estimate_detail_id = ced.estimate_detail_id;
3906: if l_order_header_id is not null and l_order_line_id is not null then
3907: select cpt.prod_txn_status
3908: into l_rma_status
3909: from csd_product_transactions cpt,
3910: cs_estimate_details ced
3911: where cpt.repair_line_id = p_repair_line_id
3912: and cpt.estimate_detail_id = ced.estimate_detail_id
3913: and ced.order_header_id = l_order_header_id
3914: and ced.order_line_id = l_order_line_id;
3963: l_prod_txn_rec.order_line_id,
3964: l_prod_txn_rec.project_id,
3965: l_prod_txn_rec.unit_number
3966: from csd_product_transactions cpt,
3967: cs_estimate_details ced
3968: where cpt.repair_line_id = p_repair_line_id and
3969: cpt.action_type = 'RMA' and
3970: cpt.action_code = 'CUST_PROD' and
3971: cpt.prod_txn_status <> 'RECEIVED' and
4012: l_prod_txn_rec.order_header_id,
4013: l_prod_txn_rec.order_line_id,
4014: l_prod_txn_rec.project_id
4015: from csd_product_transactions cpt,
4016: cs_estimate_details ced
4017: where cpt.repair_line_id = p_repair_line_id and
4018: cpt.action_type = 'RMA' and
4019: cpt.action_code = 'LOANER' and
4020: cpt.prod_txn_status <> 'RECEIVED' and
4045: if l_add_to_order_ro = 'Y' then
4046: Select max(ced.order_header_id)
4047: into l_prod_txn_rec.add_to_order_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
4114:
4115: select ced.order_header_id,ced.order_line_id
4116: into px_order_header_id,px_order_line_id
4117: from csd_product_transactions cpt,
4118: cs_estimate_details ced
4119: where cpt.repair_line_id = p_repair_line_id
4120: and ced.estimate_detail_id = cpt.estimate_detail_id
4121: and ced.estimate_detail_id = l_prod_txn_rec.estimate_detail_id
4122: and cpt.action_type = 'RMA';
4208: l_prod_txn_rec.business_process_id,l_prod_txn_rec.currency_code,
4209: l_prod_txn_rec.ship_to_party_id,l_prod_txn_rec.ship_to_account_id,
4210: l_prod_txn_rec.return_reason,l_prod_txn_rec.contract_line_id
4211: from csd_product_transactions cpt,
4212: cs_estimate_details ced
4213: where cpt.repair_line_id = p_repair_line_id and
4214: ced.estimate_detail_id = cpt.estimate_detail_id and
4215: cpt.action_type = 'SHIP' and
4216: rownum < 2;