DBA Data[Home] [Help]

APPS.CSTPACWC dependencies on FND_CURRENCIES

Line 3327: fnd_currencies c1

3323: i_prog_id, sysdate
3324: FROM mtl_cst_txn_cost_details mctcd,
3325: mtl_material_transactions mmt,
3326: wip_discrete_jobs wdj,
3327: fnd_currencies c1
3328: WHERE mctcd.transaction_id = mmt.transaction_id
3329: AND mmt.transaction_source_id = wdj.wip_entity_id
3330: AND mctcd.transaction_id = i_trx_id
3331: AND mctcd.transaction_cost < 0

Line 3391: fnd_currencies c1

3387: i_prog_id, sysdate
3388: FROM mtl_cst_txn_cost_details mctcd,
3389: mtl_material_transactions mmt,
3390: wip_discrete_jobs wdj,
3391: fnd_currencies c1
3392: WHERE mctcd.transaction_id = mmt.transaction_id
3393: AND mmt.transaction_source_id = wdj.wip_entity_id
3394: AND mctcd.transaction_id = i_trx_id
3395: AND mctcd.transaction_cost < 0

Line 3447: fnd_currencies c1

3443: i_prog_id, sysdate
3444: FROM mtl_cst_txn_cost_details mctcd,
3445: mtl_material_transactions mmt,
3446: wip_discrete_jobs wdj,
3447: fnd_currencies c1
3448: WHERE mctcd.transaction_id = mmt.transaction_id
3449: AND mmt.transaction_source_id = wdj.wip_entity_id
3450: AND mctcd.transaction_id = i_trx_id
3451: AND mctcd.transaction_cost < 0

Line 3602: fnd_currencies c1

3598: 5,nvl(transaction_cost,0)
3599: ,0),0)))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)
3600: FROM
3601: mtl_cst_txn_cost_details mctcd,
3602: fnd_currencies c1
3603: WHERE transaction_id = i_trx_id
3604: AND transaction_cost < 0
3605: AND c1.currency_code = l_pri_curr
3606: GROUP BY c1.minimum_accountable_unit, c1.precision)