DBA Data[Home] [Help]

APPS.FND_CP_GSM_IPC dependencies on V$INSTANCE

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

473: UPDATE FND_CONCURRENT_PROCESSES
474: set SESSION_ID = s_id,
475: ORACLE_PROCESS_ID = p_id,
476: OS_PROCESS_ID = osp_id,
477: INSTANCE_NUMBER = (Select instance_number from v$instance),
478: DB_INSTANCE = (Select instance_name from v$instance),
479: SQLNET_STRING = sqlnet_str,
480: last_update_date = sysdate,
481: last_updated_by = 4

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

474: set SESSION_ID = s_id,
475: ORACLE_PROCESS_ID = p_id,
476: OS_PROCESS_ID = osp_id,
477: INSTANCE_NUMBER = (Select instance_number from v$instance),
478: DB_INSTANCE = (Select instance_name from v$instance),
479: SQLNET_STRING = sqlnet_str,
480: last_update_date = sysdate,
481: last_updated_by = 4
482: where CONCURRENT_PROCESS_ID = Handle;