1095: l_stmt_num := 34;
1096:
1097: select
1098: sum(decode(cracd.price, null, cracd.amount/ decode(poll.match_option, --Bug 15944346
1099: 'P',CSTPPACQ.get_po_rate(rt.transaction_id),
1100: 'R',CSTPPACQ.get_rcv_rate(rt.transaction_id))
1101: ,cracd.price*cracd.quantity))
1102: into
1103: l_acq_cost_ent_po
1096:
1097: select
1098: sum(decode(cracd.price, null, cracd.amount/ decode(poll.match_option, --Bug 15944346
1099: 'P',CSTPPACQ.get_po_rate(rt.transaction_id),
1100: 'R',CSTPPACQ.get_rcv_rate(rt.transaction_id))
1101: ,cracd.price*cracd.quantity))
1102: into
1103: l_acq_cost_ent_po
1104: from