DBA Data[Home] [Help]

APPS.OTA_INITIALIZATION_WF dependencies on OE_ORDER_HEADERS_ALL

Line 70: FROM OE_ORDER_HEADERS_ALL

66: CURSOR C_ORDER
67: IS
68: SELECT ORDER_NUMBER ,
69: HEADER_ID
70: FROM OE_ORDER_HEADERS_ALL
71: WHERE HEADER_ID IN(
72: SELECT HEADER_ID
73: FROM OE_ORDER_LINES_ALL
74: WHERE LINE_ID = p_line_id);

Line 184: OE_ORDER_HEADERS_ALL

180: SELECT
181: order_number ,
182: header_id
183: FROM
184: OE_ORDER_HEADERS_ALL
185: WHERE
186: HEADER_ID IN(
187: SELECT
188: HEADER_ID

Line 364: OE_ORDER_HEADERS_ALL

360: SELECT
361: order_number ,
362: header_id
363: FROM
364: OE_ORDER_HEADERS_ALL
365: WHERE
366: HEADER_ID IN(
367: SELECT
368: HEADER_ID