APPS.ISC_EDW_BOOKINGS_F_C dependencies on OE_ORDER_LINES_ALL

Line 320: oe_order_lines_all l

316: l_seq_id,
317: to_char(l.line_id),
318: to_char(l.line_id)
319: FROM oe_order_headers_all h,
320: oe_order_lines_all l
321: WHERE h.last_update_date BETWEEN g_push_from_date AND g_push_to_date
322: AND l.header_id = h.header_id
323: UNION
324: SELECT /*+ PARALLEL(l) */

Line 328: FROM oe_order_lines_all l

324: SELECT /*+ PARALLEL(l) */
325: l_seq_id,
326: to_char(l.line_id),
327: to_char(l.line_id)
328: FROM oe_order_lines_all l
329: WHERE l.last_update_date BETWEEN g_push_from_date AND g_push_to_date;
330:
331: p_count := sql%rowcount;
332:

Line 485: OE_ORDER_LINES_ALL l,

481: -2,
482: 'INVALID CURRENCY') STATUS
483: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
484: ISC_TMP_PK ftp,
485: OE_ORDER_LINES_ALL l,
486: OE_ORDER_HEADERS_ALL h,
487: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
488: GL_SETS_OF_BOOKS gl
489: WHERE ftp.pk2 = l.line_id

Line 528: OE_ORDER_LINES_ALL l,

524: -2,
525: 'INVALID CURRENCY') STATUS
526: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
527: ISC_TMP_PK ftp,
528: OE_ORDER_LINES_ALL l,
529: OE_ORDER_HEADERS_ALL h,
530: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
531: GL_SETS_OF_BOOKS gl
532: WHERE ftp.pk2 = l.line_id

Line 571: OE_ORDER_LINES_ALL l,

567: -2,
568: 'INVALID CURRENCY') STATUS
569: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
570: ISC_TMP_PK ftp,
571: OE_ORDER_LINES_ALL l,
572: OE_ORDER_HEADERS_ALL h,
573: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
574: GL_SETS_OF_BOOKS gl
575: WHERE ftp.pk2 = l.line_id

Line 615: OE_ORDER_LINES_ALL l,

611: -2,
612: 'INVALID CURRENCY') STATUS
613: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
614: ISC_TMP_PK ftp,
615: OE_ORDER_LINES_ALL l,
616: OE_ORDER_HEADERS_ALL h,
617: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
618: GL_SETS_OF_BOOKS gl,
619: GL_SETS_OF_BOOKS gl_cost,

Line 670: OE_ORDER_LINES_ALL l,

666: ||' : '||nvl(description,'Description unavailable')
667: ITEM_NAME,
668: 'UOM ISSUE' STATUS
669: FROM ISC_TMP_PK ftp,
670: OE_ORDER_LINES_ALL l,
671: OE_ORDER_HEADERS_ALL h,
672: MTL_SYSTEM_ITEMS_B mtl
673: WHERE ftp.pk2 = l.line_id
674: AND ftp.seq_id = g_seq_id_line_1

Line 879: FROM OE_ORDER_LINES_ALL l

875: ''NA_EDW''
876: FROM ISC_EDW_BOOK_DEL@'||l_edw_apps_to_wh||' del
877: WHERE del.inst_name = '''||l_edw_local_instance|| '''
878: AND NOT EXISTS ( SELECT l.line_id
879: FROM OE_ORDER_LINES_ALL l
880: WHERE l.line_id = del.line_id)
881: UNION ALL
882: SELECT /*+ INDEX(del ISC_EDW_BOOK_DEL_N1)*/
883: del.BOOKINGS_PK,