DBA Data[Home] [Help]

APPS.CSTPACWC dependencies on FND_CURRENCIES

Line 3185: fnd_currencies c1

3181: i_prog_id, sysdate
3182: FROM mtl_cst_txn_cost_details mctcd,
3183: mtl_material_transactions mmt,
3184: wip_discrete_jobs wdj,
3185: fnd_currencies c1
3186: WHERE mctcd.transaction_id = mmt.transaction_id
3187: AND mmt.transaction_source_id = wdj.wip_entity_id
3188: AND mctcd.transaction_id = i_trx_id
3189: AND mctcd.transaction_cost < 0

Line 3249: fnd_currencies c1

3245: i_prog_id, sysdate
3246: FROM mtl_cst_txn_cost_details mctcd,
3247: mtl_material_transactions mmt,
3248: wip_discrete_jobs wdj,
3249: fnd_currencies c1
3250: WHERE mctcd.transaction_id = mmt.transaction_id
3251: AND mmt.transaction_source_id = wdj.wip_entity_id
3252: AND mctcd.transaction_id = i_trx_id
3253: AND mctcd.transaction_cost < 0

Line 3305: fnd_currencies c1

3301: i_prog_id, sysdate
3302: FROM mtl_cst_txn_cost_details mctcd,
3303: mtl_material_transactions mmt,
3304: wip_discrete_jobs wdj,
3305: fnd_currencies c1
3306: WHERE mctcd.transaction_id = mmt.transaction_id
3307: AND mmt.transaction_source_id = wdj.wip_entity_id
3308: AND mctcd.transaction_id = i_trx_id
3309: AND mctcd.transaction_cost < 0

Line 3437: fnd_currencies c1

3433: 5,nvl(transaction_cost,0)
3434: ,0),0)))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)
3435: FROM
3436: mtl_cst_txn_cost_details mctcd,
3437: fnd_currencies c1
3438: WHERE transaction_id = i_trx_id
3439: AND transaction_cost < 0
3440: AND c1.currency_code = l_pri_curr
3441: GROUP BY c1.minimum_accountable_unit, c1.precision)