APPS.ISC_EDW_BACKLOGS_F_C dependencies on OE_ORDER_HEADERS_ALL

Line 242: FROM oe_order_headers_all h,

238: PK1)
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

Line 336: OE_ORDER_HEADERS_ALL h,

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
340: AND ftp.seq_id = g_seq_id_line

Line 378: OE_ORDER_HEADERS_ALL h,

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
382: AND ftp.seq_id = g_seq_id_line

Line 420: OE_ORDER_HEADERS_ALL h,

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
424: AND ftp.seq_id = g_seq_id_line

Line 462: OE_ORDER_HEADERS_ALL h,

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,
466: HR_ORGANIZATION_INFORMATION hoi

Line 518: OE_ORDER_HEADERS_ALL h,

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
522: AND l.header_id = h.header_id