DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOGS_F_C dependencies on EDW_LOCAL_SYSTEM_PARAMETERS

Line 333: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,

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,
337: FINANCIALS_SYSTEM_PARAMS_ALL fspa,

Line 375: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,

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,
379: FINANCIALS_SYSTEM_PARAMS_ALL fspa,

Line 417: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,

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,
421: FINANCIALS_SYSTEM_PARAMS_ALL fspa,

Line 459: FROM EDW_LOCAL_SYSTEM_PARAMETERS edw_param,

455: h.booked_date,
456: edw_param.rate_type),
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,