[Home] [Help]
382: x_partner_order_rec.END_CUSTOMER_ID,
383: x_partner_order_rec.END_CUSTOMER_CONTACT_ID,
384: x_partner_order_rec.END_CUSTOMER_SITE_USE_ID,
385: x_partner_order_rec.SOLD_TO_SITE_USE_ID
386: FROM oe_order_lines_all oel,
387: oe_order_headers_all oeh
388: WHERE oel.line_id = l_rma_line_id
389: AND oeh.header_id = oel.header_id;
390:
458: WHERE transaction_id = p_mtl_txn_id;
459:
460: SELECT nvl(reference_line_id , fnd_api.g_miss_num)
461: INTO x_src_order_rec.original_order_line_id
462: FROM oe_order_lines_all
463: WHERE line_id = x_src_order_rec.rma_line_id;
464:
465: IF x_src_order_rec.rma_line_id IS NOT NULL THEN
466:
472: INTO x_src_order_rec.customer_account_id,
473: l_ship_to_org,
474: l_invoice_to_org,
475: x_src_order_rec.original_order_qty
476: FROM oe_order_lines_all oel, oe_order_headers_all oeh
477: WHERE line_id = x_src_order_rec.rma_line_id
478: AND oeh.header_id = oel.header_id;
479:
480: debug(' Original Order Line ID: '||x_src_order_rec.original_order_line_id);
2716:
2717: dump_txn_status_tbl(
2718: p_mtl_txn_tbl => l_src_mtl_txn_tbl);
2719:
2720: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
2721: l_txn_line_rec.source_transaction_id := l_src_mtl_txn_tbl(1).oe_line_id;
2722:
2723: l_td_found := csi_t_txn_details_pvt.check_txn_details_exist(
2724: p_txn_line_rec => l_txn_line_rec);
2725:
2726: IF l_td_found THEN
2727: debug('Transaction details found for the RMA Order.');
2728:
2729: l_txn_line_query_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
2730: l_txn_line_query_rec.source_transaction_id := l_src_mtl_txn_tbl(1).oe_line_id;
2731: l_txn_line_detail_query_rec.source_transaction_flag := 'Y';
2732:
2733: csi_t_txn_details_grp.get_transaction_details(
3677:
3678: Begin
3679: --Assign the literals..
3680: l_literal1 := 'IN_PROCESS';
3681: l_literal2 := 'OE_ORDER_LINES_ALL';
3682:
3683: UPDATE csi_t_txn_line_details a
3684: SET error_code = NULL,
3685: error_explanation = NULL ,
3700: debug('RMA Receipt Interface Successful for Material Transaction ID :'||p_mtl_txn_id);
3701:
3702: IF l_td_found THEN
3703: debug('Processing Transaction details in case of Partial RMA receipts.');
3704: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3705: l_txn_line_rec.source_transaction_id := l_rma_order_rec.source_line_id; -- l_src_mtl_txn_tbl(1).oe_line_id;
3706: l_txn_line_rec.source_transaction_type_id := 53;
3707: l_split_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3708: l_split_txn_line_rec.source_transaction_type_id := 53;
3703: debug('Processing Transaction details in case of Partial RMA receipts.');
3704: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3705: l_txn_line_rec.source_transaction_id := l_rma_order_rec.source_line_id; -- l_src_mtl_txn_tbl(1).oe_line_id;
3706: l_txn_line_rec.source_transaction_type_id := 53;
3707: l_split_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3708: l_split_txn_line_rec.source_transaction_type_id := 53;
3709: l_line_dtl_tbl(1).inv_mtl_transaction_id := p_mtl_txn_id;
3710: l_td_found := FALSE;
3711:
3713: SELECT line_id,
3714: header_id
3715: INTO l_split_txn_line_rec.source_transaction_id,
3716: l_split_txn_line_rec.source_txn_header_id
3717: FROM oe_order_lines_all
3718: WHERE split_from_line_id = l_rma_order_rec.source_line_id --l_src_mtl_txn_tbl(1).oe_line_id
3719: AND header_id = l_rma_order_rec.source_header_id ;
3720:
3721: l_partial_receipt := TRUE;
3825: x_mtl_trx_type.source_header_ref,
3826: x_mtl_trx_type.source_line_id,
3827: x_mtl_trx_type.source_line_ref
3828: FROM oe_order_headers_all ooh,
3829: oe_order_lines_all ool
3830: WHERE ool.line_id = x_mtl_trx_type.source_line_id
3831: AND ool.header_id = ooh.header_id;
3832:
3833: EXCEPTION