[Home] [Help]
467: stmt_num := 140;
468:
469: select count(*)
470: into l_mtl_txn_exists
471: from mtl_cst_txn_cost_details
472: where transaction_id = l_trx_id;
473:
474: IF( l_mtl_txn_exists=0 AND
475: ( l_action_id=30 OR l_action_id=31 OR l_action_id=32 ) ) THEN
476:
477:
478: stmt_num := 150;
479:
480: INSERT INTO mtl_cst_txn_cost_details
481: (
482: TRANSACTION_ID,
483: ORGANIZATION_ID,
484: INVENTORY_ITEM_ID,