APPS.CSTPLENG dependencies on MTL_TXN_COST_DET_INTERFACE

Line 5390: FROM MTL_TXN_COST_DET_INTERFACE

5386: o_err_msg := '';
5387:
5388: SELECT count(*)
5389: INTO l_num_detail
5390: FROM MTL_TXN_COST_DET_INTERFACE
5391: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
5392:
5393: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
5394: * OR i_txn_interface_id is null.

Line 5393: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE

5389: INTO l_num_detail
5390: FROM MTL_TXN_COST_DET_INTERFACE
5391: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
5392:
5393: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
5394: * OR i_txn_interface_id is null.
5395: * In this case, call cstpacit.cost_det_new_insert.
5396: */
5397:

Line 5474: from MTL_TXN_COST_DET_INTERFACE mtcdi

5470: (select
5471: mtcdi.VALUE_CHANGE,
5472: mtcdi.PERCENTAGE_CHANGE,
5473: mtcdi.NEW_AVERAGE_COST
5474: from MTL_TXN_COST_DET_INTERFACE mtcdi
5475: where mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
5476: and mctcd.transaction_id = i_txn_id
5477: and mtcdi.level_type = mctcd.level_type
5478: and mtcdi.cost_element_id = mctcd.cost_element_id

Line 5483: from MTL_TXN_COST_DET_INTERFACE mtcdi

5479: )
5480: where
5481: mctcd.transaction_id = i_txn_id
5482: and exists (select 1
5483: from MTL_TXN_COST_DET_INTERFACE mtcdi
5484: where mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
5485: and mtcdi.level_type = mctcd.level_type
5486: and mtcdi.cost_element_id = mctcd.cost_element_id);
5487: