DBA Data[Home] [Help]

APPS.FV_SLA_CST_PROCESSING_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 108: FROM mtl_transaction_accounts mta

104: SELECT -1*mta.base_transaction_value accounted_amount,
105: -1*NVL(mta.transaction_value, mta.base_transaction_value) entered_amount
106: INTO p_enc_accounted_amount,
107: p_enc_entered_amount
108: FROM mtl_transaction_accounts mta
109: WHERE mta.transaction_id=p_transacton_id
110: AND mta.accounting_line_type = 15;
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN

Line 120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);

116: p_error_code := c_FAILURE;
117: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
118: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
119: p_error_desc := fnd_message.get;
120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);
121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);
122: END;
123: ELSE
124: p_enc_accounted_amount := 0;

Line 121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);

117: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
118: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
119: p_error_desc := fnd_message.get;
120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);
121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);
122: END;
123: ELSE
124: p_enc_accounted_amount := 0;
125: p_enc_entered_amount := 0;

Line 255: mtl_transaction_accounts mta,

251: rt.currency_conversion_rate,
252: mmt.transaction_id transaction_id,
253: -1 accounting_event_id
254: FROM mtl_material_transactions mmt,
255: mtl_transaction_accounts mta,
256: rcv_transactions rt,
257: xla_events_gt xeg,
258: po_distributions_all pod
259: WHERE xeg.source_id_int_1 = mmt.transaction_id