[Home] [Help]
383: x_partner_order_rec.END_CUSTOMER_ID,
384: x_partner_order_rec.END_CUSTOMER_CONTACT_ID,
385: x_partner_order_rec.END_CUSTOMER_SITE_USE_ID,
386: x_partner_order_rec.SOLD_TO_SITE_USE_ID
387: FROM oe_order_lines_all oel,
388: oe_order_headers_all oeh
389: WHERE oel.line_id = l_rma_line_id
390: AND oeh.header_id = oel.header_id;
391:
459: WHERE transaction_id = p_mtl_txn_id;
460:
461: SELECT nvl(reference_line_id , fnd_api.g_miss_num)
462: INTO x_src_order_rec.original_order_line_id
463: FROM oe_order_lines_all
464: WHERE line_id = x_src_order_rec.rma_line_id;
465:
466: IF x_src_order_rec.rma_line_id IS NOT NULL THEN
467:
473: INTO x_src_order_rec.customer_account_id,
474: l_ship_to_org,
475: l_invoice_to_org,
476: x_src_order_rec.original_order_qty
477: FROM oe_order_lines_all oel, oe_order_headers_all oeh
478: WHERE line_id = x_src_order_rec.rma_line_id
479: AND oeh.header_id = oel.header_id;
480:
481: debug(' Original Order Line ID: '||x_src_order_rec.original_order_line_id);
2755:
2756: dump_txn_status_tbl(
2757: p_mtl_txn_tbl => l_src_mtl_txn_tbl);
2758:
2759: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
2760: l_txn_line_rec.source_transaction_id := l_src_mtl_txn_tbl(1).oe_line_id;
2761:
2762: l_td_found := csi_t_txn_details_pvt.check_txn_details_exist(
2763: p_txn_line_rec => l_txn_line_rec);
2764:
2765: IF l_td_found THEN
2766: debug('Transaction details found for the RMA Order.');
2767:
2768: l_txn_line_query_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
2769: l_txn_line_query_rec.source_transaction_id := l_src_mtl_txn_tbl(1).oe_line_id;
2770: l_txn_line_detail_query_rec.source_transaction_flag := 'Y';
2771:
2772: csi_t_txn_details_grp.get_transaction_details(
3716:
3717: Begin
3718: --Assign the literals..
3719: l_literal1 := 'IN_PROCESS';
3720: l_literal2 := 'OE_ORDER_LINES_ALL';
3721:
3722: UPDATE csi_t_txn_line_details a
3723: SET error_code = NULL,
3724: error_explanation = NULL ,
3739: debug('RMA Receipt Interface Successful for Material Transaction ID :'||p_mtl_txn_id);
3740:
3741: IF l_td_found THEN
3742: debug('Processing Transaction details in case of Partial RMA receipts.');
3743: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3744: l_txn_line_rec.source_transaction_id := l_rma_order_rec.source_line_id; -- l_src_mtl_txn_tbl(1).oe_line_id;
3745: l_txn_line_rec.source_transaction_type_id := 53;
3746: l_split_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3747: l_split_txn_line_rec.source_transaction_type_id := 53;
3742: debug('Processing Transaction details in case of Partial RMA receipts.');
3743: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3744: l_txn_line_rec.source_transaction_id := l_rma_order_rec.source_line_id; -- l_src_mtl_txn_tbl(1).oe_line_id;
3745: l_txn_line_rec.source_transaction_type_id := 53;
3746: l_split_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
3747: l_split_txn_line_rec.source_transaction_type_id := 53;
3748: l_line_dtl_tbl(1).inv_mtl_transaction_id := p_mtl_txn_id;
3749: l_td_found := FALSE;
3750:
3752: SELECT line_id,
3753: header_id
3754: INTO l_split_txn_line_rec.source_transaction_id,
3755: l_split_txn_line_rec.source_txn_header_id
3756: FROM oe_order_lines_all
3757: WHERE split_from_line_id = l_rma_order_rec.source_line_id --l_src_mtl_txn_tbl(1).oe_line_id
3758: AND header_id = l_rma_order_rec.source_header_id ;
3759:
3760: l_partial_receipt := TRUE;
3864: x_mtl_trx_type.source_header_ref,
3865: x_mtl_trx_type.source_line_id,
3866: x_mtl_trx_type.source_line_ref
3867: FROM oe_order_headers_all ooh,
3868: oe_order_lines_all ool
3869: WHERE ool.line_id = x_mtl_trx_type.source_line_id
3870: AND ool.header_id = ooh.header_id;
3871:
3872: EXCEPTION