DBA Data[Home] [Help]

APPS.OE_BIS dependencies on OE_BIS_BILLINGS_V

Line 204: from oe_bis_billings_v

200: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
201: trunc(sysdate),'Corporate'),
202: 1) *
203: invoiced_selling_price)
204: from oe_bis_billings_v
205: where invoicing_date between p_period_start and p_period_end
206: and nvl(p_org_id,ou_id) = ou_id
207: and customer_id = c.customer_id);
208:

Line 314: from oe_bis_billings_v

310: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
311: trunc(sysdate),'Corporate'),
312: 1) *
313: invoiced_selling_price)
314: from oe_bis_billings_v
315: where invoicing_date between bbb.period_start and bbb.period_end
316: and nvl(p_org_id,ou_id) = ou_id);
317:
318: update oe_bis_bbb_info bbb set