DBA Data[Home] [Help]

APPS.FND_CP_GSM_IPC dependencies on V$INSTANCE

Line 455: INSTANCE_NUMBER = (Select instance_number from v$instance),

451: UPDATE FND_CONCURRENT_PROCESSES
452: set SESSION_ID = s_id,
453: ORACLE_PROCESS_ID = p_id,
454: OS_PROCESS_ID = osp_id,
455: INSTANCE_NUMBER = (Select instance_number from v$instance),
456: DB_INSTANCE = (Select instance_name from v$instance),
457: SQLNET_STRING = sqlnet_str,
458: last_update_date = sysdate,
459: last_updated_by = 4

Line 456: DB_INSTANCE = (Select instance_name from v$instance),

452: set SESSION_ID = s_id,
453: ORACLE_PROCESS_ID = p_id,
454: OS_PROCESS_ID = osp_id,
455: INSTANCE_NUMBER = (Select instance_number from v$instance),
456: DB_INSTANCE = (Select instance_name from v$instance),
457: SQLNET_STRING = sqlnet_str,
458: last_update_date = sysdate,
459: last_updated_by = 4
460: where CONCURRENT_PROCESS_ID = Handle;