DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.FND_CONC_REQ_SUMMARY_V

Object Details
Object Name: FND_CONC_REQ_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_CONC_REQ_SUMMARY_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
REQUEST_ID NUMBER (15) Yes
PHASE_CODE VARCHAR2 (1) Yes
STATUS_CODE VARCHAR2 (1) Yes
PRIORITY_REQUEST_ID NUMBER (15) Yes
PRIORITY NUMBER (15) Yes
REQUEST_DATE DATE
Yes
REQUESTED_BY NUMBER (15) Yes
REQUESTED_START_DATE DATE
Yes
HOLD_FLAG VARCHAR2 (1) Yes
HAS_SUB_REQUEST VARCHAR2 (1) Yes
IS_SUB_REQUEST VARCHAR2 (1) Yes
UPDATE_PROTECTED VARCHAR2 (1) Yes
QUEUE_METHOD_CODE VARCHAR2 (1) Yes
RESPONSIBILITY_APPLICATION_ID NUMBER (15) Yes
RESPONSIBILITY_ID NUMBER (15) Yes
SAVE_OUTPUT_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PRINTER VARCHAR2 (30)

PRINT_STYLE VARCHAR2 (30)

PARENT_REQUEST_ID NUMBER (15)

CONTROLLING_MANAGER NUMBER (15)

ACTUAL_START_DATE DATE


ACTUAL_COMPLETION_DATE DATE


COMPLETION_TEXT VARCHAR2 (240)

ARGUMENT_TEXT VARCHAR2 (240)
Concurrent Request Argument
IMPLICIT_CODE VARCHAR2 (1) Yes
REQUEST_TYPE VARCHAR2 (1)
Specialization type
PROGRAM_APPLICATION_ID NUMBER (15) Yes
CONCURRENT_PROGRAM_ID NUMBER (15) Yes
PROGRAM_SHORT_NAME VARCHAR2 (30) Yes
EXECUTION_METHOD_CODE VARCHAR2 (1) Yes
ENABLED VARCHAR2 (1) Yes
PROGRAM VARCHAR2 (483)

FCP_PRINTER VARCHAR2 (30)

FCP_PRINT_STYLE VARCHAR2 (30)

FCP_REQUIRED_STYLE VARCHAR2 (1) Yes
REQUESTOR VARCHAR2 (100) Yes
USER_PRINT_STYLE VARCHAR2 (80)

DESCRIPTION VARCHAR2 (240)
DESCRIPTION
USER_CONCURRENT_PROGRAM_NAME VARCHAR2 (240) Yes USER_CONCURRENT_PROGRAM_NAME
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      REQUEST_ID
,      PHASE_CODE
,      STATUS_CODE
,      PRIORITY_REQUEST_ID
,      PRIORITY
,      REQUEST_DATE
,      REQUESTED_BY
,      REQUESTED_START_DATE
,      HOLD_FLAG
,      HAS_SUB_REQUEST
,      IS_SUB_REQUEST
,      UPDATE_PROTECTED
,      QUEUE_METHOD_CODE
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      SAVE_OUTPUT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRINTER
,      PRINT_STYLE
,      PARENT_REQUEST_ID
,      CONTROLLING_MANAGER
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      COMPLETION_TEXT
,      ARGUMENT_TEXT
,      IMPLICIT_CODE
,      REQUEST_TYPE
,      PROGRAM_APPLICATION_ID
,      CONCURRENT_PROGRAM_ID
,      PROGRAM_SHORT_NAME
,      EXECUTION_METHOD_CODE
,      ENABLED
,      PROGRAM
,      FCP_PRINTER
,      FCP_PRINT_STYLE
,      FCP_REQUIRED_STYLE
,      REQUESTOR
,      USER_PRINT_STYLE
,      DESCRIPTION
,      USER_CONCURRENT_PROGRAM_NAME
FROM APPS.FND_CONC_REQ_SUMMARY_V;

Dependencies

[top of page]

APPS.FND_CONC_REQ_SUMMARY_V references the following:

SchemaAPPS
SynonymFND_CONCURRENT_PROGRAMS
SynonymFND_CONCURRENT_PROGRAMS_TL
SynonymFND_CONCURRENT_REQUESTS
SynonymFND_PRINTER_STYLES_TL
SynonymFND_USER
APPS.FND_CONC_REQ_SUMMARY_V is referenced by following:

SchemaAPPS
Package BodyAP_XML_INVOICE_INBOUND_PKG - show dependent code
Package BodyFA_CALC_DEPRN_BASIS1_PKG - show dependent code
Package BodyFA_CDE_PKG - show dependent code
Package BodyFND_DIAG_REQUEST_ANALYZER - show dependent code
Package BodyHZ_IMP_LOAD_WRAPPER - show dependent code
Package BodyIEX_DELINQUENCY_PUB - show dependent code
Package BodyIEX_PAYMENTS_BATCH_PUB - show dependent code
Package BodyPAY_DK_ABSR_PKG - show dependent code
Package BodyPAY_DK_EINR - show dependent code
Package BodyPAY_DK_PR_ASG - show dependent code
Package BodyPAY_DK_PR_ELE - show dependent code
Package BodyPAY_DK_PR_LE - show dependent code
Package BodyPAY_DK_PR_ORG - show dependent code
Package BodyPAY_DK_STATSR_PKG - show dependent code
Package BodyPAY_FI_ACRR - show dependent code
Package BodyPAY_FI_DPSR - show dependent code
Package BodyPAY_FI_LTFR - show dependent code
Package BodyPAY_FI_MTRR - show dependent code
Package BodyPAY_FI_PAYLIST - show dependent code
Package BodyPAY_FI_PSTR - show dependent code
Package BodyPAY_FI_TELR - show dependent code
Package BodyPAY_FI_UMFR - show dependent code
Package BodyPAY_GB_EPS - show dependent code
Package BodyPAY_GB_EPS_13 - show dependent code
Package BodyPAY_NO_ABS_STATISTICS_REPORT - show dependent code
Package BodyPAY_NO_ARC_RSEA_07 - show dependent code
Package BodyPAY_NO_EERR_CONTINUOUS - show dependent code
Package BodyPAY_NO_EERR_STATUS_CONTROL - show dependent code
Package BodyPAY_NO_EOY_ARCHIVE - show dependent code
Package BodyPAY_NO_HOLIDAY_ENT_REPORT - show dependent code
Package BodyPAY_NO_PACCR_PKG - show dependent code
Package BodyPAY_NO_RSER - show dependent code
Package BodyPAY_NO_SAL_STATISTICS_ARCHIVE - show dependent code
Package BodyPAY_NO_SELF_CERTIFICATION_RPT - show dependent code
Package BodyPAY_NO_SUPPORT_ORDER - show dependent code
Package BodyPAY_NO_TAX_LEVY - show dependent code
Package BodyPAY_NO_UNION_DUES - show dependent code
Package BodyPAY_SE_ALECTA - show dependent code
Package BodyPAY_SE_CWCR - show dependent code
Package BodyPAY_SE_EMPLOYMENT_STATISTICS - show dependent code
Package BodyPAY_SE_FORA - show dependent code
Package BodyPAY_SE_HCIR - show dependent code
Package BodyPAY_SE_HOLIDAY_PAY_DEBT - show dependent code
Package BodyPAY_SE_INCOME_STATEMENT - show dependent code
Package BodyPAY_SE_SALARY_STRUCTURE_STATS - show dependent code
Package BodyPAY_SE_SLSR - show dependent code
Package BodyPAY_SE_STAT_OFFICE_ARCHIVE - show dependent code
Package BodyPAY_SE_TAX_DECL_REPORT - show dependent code
Package BodyPAY_SE_TETR - show dependent code
Package BodyPAY_SE_TRNR - show dependent code
Package BodyPAY_SE_WAGES_SALARIES - show dependent code
Package BodyPAY_SE_WORK_TIME_CERTIFICATE - show dependent code
Package BodyPA_PROGRESS_PUB - show dependent code
Package BodyPO_EDA_PKG - show dependent code
Package BodyQA_SOLUTION_DISPOSITION_PKG - show dependent code