[Home] [Help]
315: SELECT /*+ PARALLEL(h) */
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
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
490: AND ftp.seq_id = g_seq_id_line_1
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
533: AND ftp.seq_id = g_seq_id_line_1
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
576: AND ftp.seq_id = g_seq_id_line_1
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,
620: HR_ORGANIZATION_INFORMATION hoi
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
675: AND l.header_id = h.header_id