DBA Data[Home] [Help]

APPS.OE_BIS dependencies on OE_BIS_BACKLOG_V

Line 218: from oe_bis_backlog_v

214: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
215: trunc(sysdate),'Corporate'),
216: 1) *
217: bl_selling_price)
218: from oe_bis_backlog_v
219: where customer_id = c.customer_id
220: and nvl(p_org_id,ou_id) = ou_id);
221:
222: --lchen remove alias on_time_perent from following subquery to fix bug 1753574

Line 341: from oe_bis_backlog_v

337: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
338: trunc(sysdate),'Corporate'),
339: 1) *
340: bl_selling_price)
341: from oe_bis_backlog_v
342: where (invoiced_flag = 'N' or invoiced_date > bbb.period_end)
343: and booked_date <= bbb.period_end+1
344: and nvl(p_org_id,ou_id) = ou_id);
345: