[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',
15003: CURSOR tld_cur(p_rma_line_id in number) is
15004: SELECT ctld.sub_type_id, ctld.instance_id
15005: FROM csi_t_transaction_lines ctl,
15006: csi_t_txn_line_details ctld
15007: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
15008: AND ctl.source_transaction_id = p_rma_line_id
15009: AND ctld.transaction_line_id = ctl.transaction_line_id
15010: AND ctld.source_transaction_flag = 'Y';
15011:
15161: line.line_number||'.'||line.shipment_number
15162: INTO l_customer_id,
15163: l_rma_num,
15164: l_rma_line_num
15165: FROM oe_order_lines_all line,
15166: oe_order_headers_all hdr
15167: WHERE line.line_id = csi_rec.trx_source_line_id
15168: AND hdr.header_id = line.header_id;
15169:
15393: oel.sold_to_org_id owner_acct,
15394: oel.ordered_quantity ordered_qty,
15395: oel.order_quantity_uom ordered_uom,
15396: hca.party_id party_id
15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15398: WHERE cte.processed_flag in ('E', 'R')
15399: AND cte.transaction_type_id = 53
15400: AND cte.inv_material_transaction_id = mmt.transaction_id
15401: AND msi.inventory_item_id = mmt.inventory_item_id
15494: BEGIN
15495: SELECT transaction_line_id
15496: INTO l_transaction_line_id
15497: FROM csi_t_transaction_lines
15498: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
15499: AND source_transaction_id = l_rma_txn_tbl(i).mtl_src_line_id
15500: AND source_transaction_type_id = 53;
15501: EXCEPTION
15502: WHEN no_data_found THEN
15509: -- create transaction details
15510: l_line_rec.transaction_line_id := fnd_api.g_miss_num;
15511: l_line_rec.source_transaction_type_id := 53;
15512: l_line_rec.source_transaction_id := l_rma_txn_tbl(i).mtl_src_line_id;
15513: l_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
15514: l_line_rec.inv_material_txn_flag := 'Y';
15515: l_line_rec.object_version_number := 1.0;
15516:
15517: -- transaction line details table