APPS.OE_RETROBILL_PVT dependencies on OE_ORDER_TYPES_V

Line 4505: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id

4501: l_old_org_id NUMBER;
4502:
4503: cursor retrobill_request is
4504: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4505: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id
4506: where trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4507: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4508: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))
4509: and trunc(execution_date) <= nvl(trunc(l_execution_date_to),trunc(execution_date))

Line 4518: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id

4514:
4515:
4516: cursor retrobill_request_id is
4517: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4518: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id
4519: where retrobill_request_id = to_number(p_retrobill_request_id)
4520: and trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4521: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4522: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))