APPS.FII_AR_TRX_DIST_F_C dependencies on EDW_LOCAL_INSTANCE

Line 219: 'AND INSTANCE = (SELECT INSTANCE_CODE FROM EDW_LOCAL_INSTANCE) ' ||

215: ' temp.order_line_id ' ||
216: ' AND rev.interface_line_context = ''GEMMS OP''))) ' ||
217: 'WHERE rev.item_fk <> ''NA_EDW'' ' ||
218: 'AND rev.collection_status = ''LOCAL READY'' ' ||
219: 'AND INSTANCE = (SELECT INSTANCE_CODE FROM EDW_LOCAL_INSTANCE) ' ||
220: 'AND rev.item_fk NOT LIKE ''%-IORG'' ';
221:
222:
223: if g_debug_flag = 'Y' then

Line 347: FROM EDW_LOCAL_INSTANCE);

343:
344: DELETE FII_AR_TRX_DIST_FSTG
345: WHERE COLLECTION_STATUS = 'LOCAL READY' OR (COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
346: AND INSTANCE = (SELECT INSTANCE_CODE
347: FROM EDW_LOCAL_INSTANCE);
348:
349: END;
350:
351: --------------------------------------------------

Line 366: FROM edw_local_instance;

362:
363:
364: SELECT instance_code
365: INTO l_instance1
366: FROM edw_local_instance;
367:
368: SELECT instance_code
369: INTO l_instance2
370: FROM edw_local_instance@edw_apps_to_wh;

Line 370: FROM edw_local_instance@edw_apps_to_wh;

366: FROM edw_local_instance;
367:
368: SELECT instance_code
369: INTO l_instance2
370: FROM edw_local_instance@edw_apps_to_wh;
371:
372: IF (l_instance1 = l_instance2) THEN
373: RETURN TRUE;
374: END IF;

Line 399: FROM EDW_LOCAL_INSTANCE);

395: UPDATE FII_AR_TRX_DIST_FSTG
396: SET COLLECTION_STATUS = 'READY'
397: WHERE COLLECTION_STATUS = 'LOCAL READY'
398: AND INSTANCE = (SELECT INSTANCE_CODE
399: FROM EDW_LOCAL_INSTANCE);
400:
401: RETURN(sql%rowcount);
402:
403: EXCEPTION