DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on FND_CURRENCIES

Line 6087: fnd_currencies c1,

6083: (ROUND((nvl(sum(actual_cost),0)*abs(i_p_qty))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)/abs(i_p_qty))
6084: into l_ce_round_cost
6085: from mtl_cst_actual_cost_details cacd,
6086: cst_organization_definitions cod,
6087: fnd_currencies c1,
6088: gl_sets_of_books gsb
6089: where cacd.transaction_id = i_txn_id
6090: and cacd.organization_id = i_org_id
6091: and c1.currency_code = gsb.currency_code

Line 6761: fnd_currencies c1,

6757: 15, l_ussgl_tc, NULL),
6758: NULL),
6759: NULL)
6760: from
6761: fnd_currencies c1,
6762: fnd_currencies c2
6763: where
6764: c1.currency_code = i_pri_curr
6765: and c2.currency_code = decode(i_alt_curr, NULL, i_pri_curr, i_alt_curr);

Line 6762: fnd_currencies c2

6758: NULL),
6759: NULL)
6760: from
6761: fnd_currencies c1,
6762: fnd_currencies c2
6763: where
6764: c1.currency_code = i_pri_curr
6765: and c2.currency_code = decode(i_alt_curr, NULL, i_pri_curr, i_alt_curr);
6766: