DBA Data[Home] [Help]

APPS.CSTPACIT dependencies on CST_COST_ELEMENTS

Line 142: FROM CST_COST_ELEMENTS CCE,

138: l_stmt_num := 20;
139:
140: SELECT count(*)
141: INTO l_err_num
142: FROM CST_COST_ELEMENTS CCE,
143: MTL_TXN_COST_DET_INTERFACE MTCDI
144: WHERE MTCDI.TRANSACTION_INTERFACE_ID = i_txn_interface_id
145: AND CCE.COST_ELEMENT_ID = NVL(MTCDI.COST_ELEMENT_ID, CCE.COST_ELEMENT_ID)
146: AND CCE.COST_ELEMENT = NVL(MTCDI.COST_ELEMENT, CCE.COST_ELEMENT)

Line 224: FROM CST_COST_ELEMENTS CCE

220:
221: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI
222: SET COST_ELEMENT_ID =
223: (SELECT CCE.COST_ELEMENT_ID
224: FROM CST_COST_ELEMENTS CCE
225: WHERE CCE.COST_ELEMENT = NVL(MTCDI.COST_ELEMENT, CCE.COST_ELEMENT))
226: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
227: AND COST_ELEMENT_ID IS NULL;
228: