APPS.ISC_EDW_BACKLOGS_F_C dependencies on EDW_LOCAL_INSTANCE

Line 332: FROM EDW_LOCAL_INSTANCE inst,

328: h.booked_date,
329: nvl(h.conversion_type_code, edw_param.rate_type)))),
330: -1,'RATE NOT AVAILABLE',
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,

Line 374: FROM EDW_LOCAL_INSTANCE inst,

370: '' ITEM_NAME,
371: decode( EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date),
372: -1,'RATE NOT AVAILABLE',
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,

Line 416: FROM EDW_LOCAL_INSTANCE inst,

412: h.booked_date,
413: nvl(h.conversion_type_code, edw_param.rate_type)))),
414: -1,'RATE NOT AVAILABLE',
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,

Line 515: FROM EDW_LOCAL_INSTANCE inst,

511: nvl(mtl.segment1,'Item number unavailable')
512: ||' : '||nvl(description,'Description unavailable')
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