DBA Data[Home] [Help]

APPS.ONT_OEXAUDHR_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 169: OE_ORDER_LINES_ALL

165: COMPONENT_NUMBER,
166: SERVICE_NUMBER
167: INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
168: FROM
169: OE_ORDER_LINES_ALL
170: WHERE LINE_ID = LINEID1;
171: EXCEPTION
172: WHEN OTHERS THEN
173: RETURN NULL;

Line 185: OE_ORDER_LINES_ALL

181: COMPONENT_NUMBER,
182: SERVICE_NUMBER
183: INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
184: FROM
185: OE_ORDER_LINES_ALL
186: WHERE LINE_ID = (
187: SELECT
188: DISTINCT
189: LINE_ID

Line 207: OE_ORDER_LINES_ALL

203: COMPONENT_NUMBER,
204: SERVICE_NUMBER
205: INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
206: FROM
207: OE_ORDER_LINES_ALL
208: WHERE LINE_ID = (
209: SELECT
210: DISTINCT
211: LINE_ID