eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_EDW_BACKLOGS_F_C dependencies on OE_ORDER_LINES_ALL

Line 243: oe_order_lines_all l

239: SELECT /*+ PARALLEL(h) */
240: l_seq_id,
241: to_char(l.line_id)
242: FROM oe_order_headers_all h,
243: oe_order_lines_all l
244: WHERE h.last_update_date BETWEEN g_push_from_date AND g_push_to_date
245: AND l.header_id = h.header_id
246: AND nvl(l.ordered_quantity,0) > 0
247: AND nvl(l.source_document_type_id,0) <> 10

Line 253: FROM oe_order_lines_all l

249: UNION
250: SELECT /*+ PARALLEL(l) */
251: l_seq_id,
252: to_char(l.line_id)
253: FROM oe_order_lines_all l
254: WHERE l.last_update_date BETWEEN g_push_from_date AND g_push_to_date
255: AND nvl(l.ordered_quantity,0) > 0
256: AND nvl(l.source_document_type_id,0) <> 10
257: AND l.line_category_code = ('ORDER');

Line 335: OE_ORDER_LINES_ALL l,

331: -2,'INVALID CURRENCY') STATUS
332: FROM EDW_LOCAL_INSTANCE inst,
333: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
334: ISC_TMP_BACK ftp,
335: OE_ORDER_LINES_ALL l,
336: OE_ORDER_HEADERS_ALL h,
337: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
338: GL_SETS_OF_BOOKS gl
339: WHERE ftp.pk1 = l.line_id

Line 377: OE_ORDER_LINES_ALL l,

373: -2,'INVALID CURRENCY') STATUS
374: FROM EDW_LOCAL_INSTANCE inst,
375: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
376: ISC_TMP_BACK ftp,
377: OE_ORDER_LINES_ALL l,
378: OE_ORDER_HEADERS_ALL h,
379: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
380: GL_SETS_OF_BOOKS gl
381: WHERE ftp.pk1 = l.line_id

Line 419: OE_ORDER_LINES_ALL l,

415: -2,'INVALID CURRENCY') STATUS
416: FROM EDW_LOCAL_INSTANCE inst,
417: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
418: ISC_TMP_BACK ftp,
419: OE_ORDER_LINES_ALL l,
420: OE_ORDER_HEADERS_ALL h,
421: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
422: GL_SETS_OF_BOOKS gl
423: WHERE ftp.pk1 = l.line_id

Line 461: OE_ORDER_LINES_ALL l,

457: -1,'RATE NOT AVAILABLE',
458: -2,'INVALID CURRENCY') STATUS
459: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,
460: ISC_TMP_PK ftp,
461: OE_ORDER_LINES_ALL l,
462: OE_ORDER_HEADERS_ALL h,
463: FINANCIALS_SYSTEM_PARAMS_ALL fspa,
464: GL_SETS_OF_BOOKS gl,
465: GL_SETS_OF_BOOKS gl_cost,

Line 517: OE_ORDER_LINES_ALL l,

513: ITEM_NAME,
514: 'UOM ISSUE' STATUS
515: FROM EDW_LOCAL_INSTANCE inst,
516: ISC_TMP_BACK ftp,
517: OE_ORDER_LINES_ALL l,
518: OE_ORDER_HEADERS_ALL h,
519: MTL_SYSTEM_ITEMS_B mtl
520: WHERE ftp.pk1 = l.line_id
521: AND ftp.seq_id = g_seq_id_line