APPS.OE_RETROBILL_PVT dependencies on OE_ORDER_TYPES_V

Line 4080: 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

4076: l_old_org_id NUMBER;
4077:
4078: cursor retrobill_request is
4079: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4080: 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
4081: where trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4082: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4083: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))
4084: and trunc(execution_date) <= nvl(trunc(l_execution_date_to),trunc(execution_date))

Line 4093: 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

4089:
4090:
4091: cursor retrobill_request_id is
4092: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4093: 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
4094: where retrobill_request_id = to_number(p_retrobill_request_id)
4095: and trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4096: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4097: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))