APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_TYPES_V

Line 143: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects

139: l_org_id NUMBER;
140:
141: CURSOR cur_get_org_for_ord_type IS
142: SELECT org_id
143: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects
144: WHERE order_type_id = p_order_type_id;
145:
146: BEGIN
147: --Bug #4220950

Line 205: OE_ORDER_TYPES_V OOT --MOAC view based on multiple obj

201: OOH.QUOTE_NUMBER,
202: OOH.FLOW_STATUS_CODE,
203: OOH.UPGRADED_FLAG
204: FROM OE_ORDER_HEADERS_ALL OOH,
205: OE_ORDER_TYPES_V OOT --MOAC view based on multiple obj
206: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
207: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')<>''N''';
208:
209:

Line 258: FROM OE_ORDER_TYPES_V --MOAC view based on multiple obj

254: THEN
255: l_sql_stmt := l_sql_stmt || ' AND OOH.ORDER_TYPE_ID = :p3';
256: SELECT NAME
257: INTO l_order_type_name
258: FROM OE_ORDER_TYPES_V --MOAC view based on multiple obj
259: WHERE ORDER_TYPE_ID = p_order_type_id;
260:
261: IF l_where_condition IS NULL
262: THEN

Line 644: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects

640: l_org_id NUMBER;
641:
642: CURSOR cur_get_org_for_ord_type IS
643: SELECT org_id
644: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects
645: WHERE order_type_id = p_order_type_id;
646:
647: BEGIN
648: --Bug #4220950

Line 699: OE_ORDER_TYPES_V OOT --MOAC view based on multiple objects

695: OOH.EXPIRATION_DATE,
696: OOH.FLOW_STATUS_CODE,
697: OOH.UPGRADED_FLAG
698: FROM OE_ORDER_HEADERS_ALL OOH,
699: OE_ORDER_TYPES_V OOT --MOAC view based on multiple objects
700: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
701: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')=''N''';
702:
703:

Line 746: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects

742: --Order Type
743: IF p_order_type_id is NOT NULL THEN
744: SELECT NAME
745: INTO l_order_type_name
746: FROM OE_ORDER_TYPES_V --MOAC view based on multiple objects
747: WHERE ORDER_TYPE_ID = p_order_type_id;
748:
749: l_sql_stmt := l_sql_stmt || ' AND OOH.ORDER_TYPE_ID = :p3';
750:

Line 1118: From oe_order_types_v oot, --MOAC view based on multiple objects

1114: , l_expiration_date
1115: , l_flow_status_code
1116: , l_upgraded_flag
1117: , l_transaction_phase_code
1118: From oe_order_types_v oot, --MOAC view based on multiple objects
1119: oe_order_headers_all ooh
1120:
1121: WHERE
1122: ooh.header_id = l_header_id

Line 1918: oe_order_types_v ot --MOAC view based on multiple objects

1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number
1920: AND sh.order_type_id = ot.order_type_id
1921: AND ot.name = p_order_type_name
1922: AND sl1.header_id = sh.header_id