[Home] [Help]
331: AND organization_id = p_organization_id
332: START WITH transaction_id = p_rcv_transaction_id
333: CONNECT BY parent_transaction_id = PRIOR transaction_id
334: ) rt,
335: mtl_material_transactions mmt,
336: mtl_secondary_inventories mse
337: WHERE rt.transaction_id = mmt.rcv_transaction_id
338: AND mse.secondary_inventory_name = mmt.subinventory_code
339: AND mse.organization_id = mmt.organization_id
1476: l_recs_processed := l_recs_processed + 1;
1477: l_stmt_num := 1100;
1478: Delete from mtl_pac_txn_cost_details mptcd
1479: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1480: FROM mtl_material_transactions mmt,
1481: cst_rcv_acq_costs_adj craca
1482: WHERE mmt.rcv_transaction_id
1483: = c_rec.rcv_transaction_id
1484: AND mmt.transaction_source_id
1494: AND mmt.transaction_type_id = 26
1495: AND mmt.transaction_source_type_id = 14);
1496:
1497: l_stmt_num := 1110;
1498: Delete from mtl_material_transactions mmt
1499: where mmt.rcv_transaction_id = c_rec.rcv_transaction_id
1500: AND mmt.transaction_action_id = 24
1501: AND mmt.transaction_type_id = 26
1502: AND mmt.transaction_source_type_id = 14
1991: 1
1992: )
1993: Returning accounting_event_id INTO l_rcv_accounting_event_id;
1994: l_stmt_num := 1260;
1995: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1996: into l_transaction_id
1997: from dual;
1998: l_stmt_num := 1265;
1999: l_um_rate := 1;
2024: FROM mtl_system_items msi
2025: WHERE msi.organization_id = l_master_org_id
2026: AND msi.inventory_item_id = c_rec.inventory_item_id;
2027: l_stmt_num := 1270;
2028: INSERT INTO MTL_MATERIAL_TRANSACTIONS
2029: (transaction_id,
2030: last_update_date,
2031: last_updated_by,
2032: creation_date,
2257: END IF; /*prior landed cost <> new landed cost*/
2258: END LOOP;
2259: /* Update the primary_quantity of the MMT with total adjusted QTY */
2260: l_stmt_num := 1330;
2261: UPDATE mtl_material_transactions mmt
2262: SET (primary_quantity,
2263: transaction_quantity)
2264: = ( SELECT sum(mmt2.primary_quantity),
2265: sum(mmt2.transaction_quantity)
2262: SET (primary_quantity,
2263: transaction_quantity)
2264: = ( SELECT sum(mmt2.primary_quantity),
2265: sum(mmt2.transaction_quantity)
2266: FROM mtl_material_transactions mmt2
2267: WHERE mmt2.inventory_item_id =
2268: mmt.inventory_item_id
2269: AND mmt2.transaction_action_id = 24
2270: AND mmt2.transaction_type_id = 26
2378: and craca.cost_group_id = i_cost_group_id
2379: and craca.rcv_transaction_id = l_rec_transaction_id
2380: and craca.cost_type_id = i_cost_type_id );
2381:
2382: Delete from mtl_material_transactions mmt
2383: where mmt.transaction_id IN ( select craca.mmt_transaction_id
2384: from cst_rcv_acq_costs_adj craca
2385: where craca.mmt_transaction_id is not null
2386: and craca.period_id = i_period
4326:
4327: /* bug fix for bug 3439082.Added joins on the cost group and cost type */
4328:
4329: select NVL(SUM(NVL(value_change,0)),0) into l_old_increments
4330: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca
4331: where mmt.transaction_id = craca.mmt_transaction_id
4332: and craca.mmt_transaction_id is NOT NULL
4333: and craca.cost_group_id = i_cost_group_id
4334: and craca.cost_type_id = i_cost_type_id
4446: fnd_file.put_line(fnd_file.log,'org_id : ' || to_char(i_org_id));
4447:
4448:
4449: l_stmt_num := 90;
4450: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_transaction_id
4451: from dual;
4452:
4453: /* get the period close date for the current open period */
4454:
4515: /* bug 4322574. CHanged the Costed_flag to NULL from 'N' so that the perpetual cost worker does not try and
4516: pick it up for costing */
4517:
4518:
4519: INSERT INTO MTL_MATERIAL_TRANSACTIONS
4520: (transaction_id,
4521: last_update_date,
4522: last_updated_by,
4523: creation_date,
4696: rcv_transaction_id
4697: INTO
4698: l_rcv_txn
4699: FROM
4700: mtl_material_transactions mmt
4701: WHERE
4702: mmt.transaction_id = i_txn_id AND
4703: mmt.organization_id in (
4704: SELECT