[Home] [Help]
337: AND organization_id = p_organization_id
338: START WITH transaction_id = p_rcv_transaction_id
339: CONNECT BY parent_transaction_id = PRIOR transaction_id
340: ) rt,
341: mtl_material_transactions mmt,
342: mtl_secondary_inventories mse
343: WHERE rt.transaction_id = mmt.rcv_transaction_id
344: AND mse.secondary_inventory_name = mmt.subinventory_code
345: AND mse.organization_id = mmt.organization_id
1469: l_recs_processed := l_recs_processed + 1;
1470: l_stmt_num := 1100;
1471: Delete from mtl_pac_txn_cost_details mptcd
1472: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1473: FROM mtl_material_transactions mmt,
1474: cst_rcv_acq_costs_adj craca
1475: WHERE mmt.rcv_transaction_id
1476: = c_rec.rcv_transaction_id
1477: AND mmt.transaction_source_id
1487: AND mmt.transaction_type_id = 26
1488: AND mmt.transaction_source_type_id = 14);
1489:
1490: l_stmt_num := 1110;
1491: Delete from mtl_material_transactions mmt
1492: where mmt.rcv_transaction_id = c_rec.rcv_transaction_id
1493: AND mmt.transaction_action_id = 24
1494: AND mmt.transaction_type_id = 26
1495: AND mmt.transaction_source_type_id = 14
1984: 1
1985: )
1986: Returning accounting_event_id INTO l_rcv_accounting_event_id;
1987: l_stmt_num := 1260;
1988: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1989: into l_transaction_id
1990: from dual;
1991: l_stmt_num := 1265;
1992: l_um_rate := 1;
2017: FROM mtl_system_items msi
2018: WHERE msi.organization_id = l_master_org_id
2019: AND msi.inventory_item_id = c_rec.inventory_item_id;
2020: l_stmt_num := 1270;
2021: INSERT INTO MTL_MATERIAL_TRANSACTIONS
2022: (transaction_id,
2023: last_update_date,
2024: last_updated_by,
2025: creation_date,
2250: END IF; /*prior landed cost <> new landed cost*/
2251: END LOOP;
2252: /* Update the primary_quantity of the MMT with total adjusted QTY */
2253: l_stmt_num := 1330;
2254: UPDATE mtl_material_transactions mmt
2255: SET (primary_quantity,
2256: transaction_quantity)
2257: = ( SELECT sum(mmt2.primary_quantity),
2258: sum(mmt2.transaction_quantity)
2255: SET (primary_quantity,
2256: transaction_quantity)
2257: = ( SELECT sum(mmt2.primary_quantity),
2258: sum(mmt2.transaction_quantity)
2259: FROM mtl_material_transactions mmt2
2260: WHERE mmt2.inventory_item_id =
2261: mmt.inventory_item_id
2262: AND mmt2.transaction_action_id = 24
2263: AND mmt2.transaction_type_id = 26
2330: and craca.cost_group_id = i_cost_group_id
2331: and craca.rcv_transaction_id = c_rec.transaction_id
2332: and craca.cost_type_id = i_cost_type_id );
2333:
2334: Delete from mtl_material_transactions mmt
2335: where mmt.transaction_id IN ( select craca.mmt_transaction_id
2336: from cst_rcv_acq_costs_adj craca
2337: where craca.mmt_transaction_id is not null
2338: and craca.period_id = i_period
4235:
4236: /* bug fix for bug 3439082.Added joins on the cost group and cost type */
4237:
4238: select NVL(SUM(NVL(value_change,0)),0) into l_old_increments
4239: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca
4240: where mmt.transaction_id = craca.mmt_transaction_id
4241: and craca.mmt_transaction_id is NOT NULL
4242: and craca.cost_group_id = i_cost_group_id
4243: and craca.cost_type_id = i_cost_type_id
4354: fnd_file.put_line(fnd_file.log,'item id : ' || to_char(l_item));
4355: fnd_file.put_line(fnd_file.log,'org_id : ' || to_char(i_org_id));
4356:
4357:
4358: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_transaction_id
4359: from dual;
4360:
4361: /* get the period close date for the current open period */
4362:
4378: /* bug 4322574. CHanged the Costed_flag to NULL from 'N' so that the perpetual cost worker does not try and
4379: pick it up for costing */
4380:
4381:
4382: INSERT INTO MTL_MATERIAL_TRANSACTIONS
4383: (transaction_id,
4384: last_update_date,
4385: last_updated_by,
4386: creation_date,
4551: rcv_transaction_id
4552: INTO
4553: l_rcv_txn
4554: FROM
4555: mtl_material_transactions mmt
4556: WHERE
4557: mmt.transaction_id = i_txn_id AND
4558: mmt.organization_id in (
4559: SELECT