APPS.RLM_RLMDPDER_XMLP_PKG dependencies on OE_ORDER_TYPES_V

Line 107: OE_ORDER_TYPES_V

103: SELECT
104: NAME
105: INTO P_ORDER_TYPE_NAME_FROM
106: FROM
107: OE_ORDER_TYPES_V
108: WHERE ORDER_TYPE_ID = P_ORDER_TYPE_FROM;
109: END IF;
110: IF (P_ORDER_TYPE_TO IS NOT NULL) THEN
111: P_WHERE_CLAUSE2 := P_WHERE_CLAUSE2 || ' and e.exception_id = -1';

Line 117: OE_ORDER_TYPES_V

113: SELECT
114: NAME
115: INTO P_ORDER_TYPE_NAME_TO
116: FROM
117: OE_ORDER_TYPES_V
118: WHERE ORDER_TYPE_ID = P_ORDER_TYPE_TO;
119: END IF;
120: IF (P_SCHEDULE_NUMBER_FROM IS NOT NULL) THEN
121: P_WHERE_CLAUSE := P_WHERE_CLAUSE || ' and e.schedule_reference_num >= ' || '''' || P_SCHEDULE_NUMBER_FROM || '''';

Line 248: OE_ORDER_TYPES_V

244: CURSOR ORDER_TYPE_CUR IS
245: SELECT
246: NAME
247: FROM
248: OE_ORDER_TYPES_V
249: WHERE ORDER_TYPE_ID = ORDER_TYPE_ID;
250: BEGIN
251: IF ORDER_TYPE_CUR%ISOPEN THEN
252: CLOSE ORDER_TYPE_CUR;