[Home] [Help]
3771: tld.inventory_item_id,
3772: tld.inv_organization_id
3773: FROM csi_t_txn_line_details tld,
3774: csi_t_transaction_lines tl
3775: WHERE tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
3776: AND tl.source_transaction_id = p_order_line_id
3777: AND tld.transaction_line_id = tl.transaction_line_id
3778: AND tld.instance_id is not null;
3779:
8742: CURSOR tld_cur(p_rma_line_id in number) is
8743: SELECT ctld.sub_type_id
8744: FROM csi_t_transaction_lines ctl,
8745: csi_t_txn_line_details ctld
8746: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
8747: AND ctl.source_transaction_type_id = 53
8748: AND ctl.source_transaction_id = p_rma_line_id
8749: AND ctld.transaction_line_id = ctl.transaction_line_id
8750: AND ctld.source_transaction_flag = 'Y';
8811: IF l_change_owner_flag = 'N' THEN
8812:
8813: SELECT nvl(oel.sold_to_org_id, oeh.sold_to_org_id)
8814: INTO l_owner_account_id
8815: FROM oe_order_lines_all oel,
8816: oe_order_headers_all oeh
8817: WHERE oel.line_id = l_rma_line_id
8818: AND oeh.header_id = oel.header_id;
8819:
9386: SELECT inventory_item_id,
9387: ship_from_org_id
9388: INTO l_inventory_item_id,
9389: l_organization_id
9390: FROM oe_order_lines_all
9391: WHERE line_id = l_rma_line_id_tab(ind);
9392:
9393: l_mtl_txn_id := null;
9394:
10038: when no_data_found then
10039: Begin
10040: select item_revision
10041: into revision_mig(i)
10042: from OE_ORDER_LINES_ALL
10043: where line_id = order_line_id_mig(i);
10044: Exception
10045: when no_data_found then
10046: revision_mig(i) := null;
11597: BEGIN
11598: Begin
11599: select oel.inventory_item_id,oel.org_id
11600: into l_item_id, l_org_id
11601: from OE_ORDER_LINES_ALL oel
11602: where oel.line_id = source_id_mig(i);
11603:
11604: l_organization_id := oe_sys_parameters.value(
11605: param_name => 'MASTER_ORGANIZATION_ID',
14992: CURSOR tld_cur(p_rma_line_id in number) is
14993: SELECT ctld.sub_type_id, ctld.instance_id
14994: FROM csi_t_transaction_lines ctl,
14995: csi_t_txn_line_details ctld
14996: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
14997: AND ctl.source_transaction_id = p_rma_line_id
14998: AND ctld.transaction_line_id = ctl.transaction_line_id
14999: AND ctld.source_transaction_flag = 'Y';
15000:
15150: line.line_number||'.'||line.shipment_number
15151: INTO l_customer_id,
15152: l_rma_num,
15153: l_rma_line_num
15154: FROM oe_order_lines_all line,
15155: oe_order_headers_all hdr
15156: WHERE line.line_id = csi_rec.trx_source_line_id
15157: AND hdr.header_id = line.header_id;
15158:
15382: oel.sold_to_org_id owner_acct,
15383: oel.ordered_quantity ordered_qty,
15384: oel.order_quantity_uom ordered_uom,
15385: hca.party_id party_id
15386: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15387: WHERE cte.processed_flag in ('E', 'R')
15388: AND cte.transaction_type_id = 53
15389: AND cte.inv_material_transaction_id = mmt.transaction_id
15390: AND msi.inventory_item_id = mmt.inventory_item_id
15483: BEGIN
15484: SELECT transaction_line_id
15485: INTO l_transaction_line_id
15486: FROM csi_t_transaction_lines
15487: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
15488: AND source_transaction_id = l_rma_txn_tbl(i).mtl_src_line_id
15489: AND source_transaction_type_id = 53;
15490: EXCEPTION
15491: WHEN no_data_found THEN
15498: -- create transaction details
15499: l_line_rec.transaction_line_id := fnd_api.g_miss_num;
15500: l_line_rec.source_transaction_type_id := 53;
15501: l_line_rec.source_transaction_id := l_rma_txn_tbl(i).mtl_src_line_id;
15502: l_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
15503: l_line_rec.inv_material_txn_flag := 'Y';
15504: l_line_rec.object_version_number := 1.0;
15505:
15506: -- transaction line details table