[Home] [Help]
[Dependency Information]
| Object Name: | AMW_BASIC_RCM_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CTX | VARCHAR2 | (10) | ||
| PPID | NUMBER | |||
| PPN | VARCHAR2 | (80) | ||
| PDN | VARCHAR2 | (80) | ||
| PCDE | VARCHAR2 | (30) | ||
| PID | NUMBER | |||
| PON | VARCHAR2 | (240) | ||
| POD | VARCHAR2 | (4000) | ||
| RNM | VARCHAR2 | (240) | ||
| RID | NUMBER | |||
| RR | CHAR | (1) | ||
| RDS | VARCHAR2 | (4000) | ||
| RT1 | CHAR | (1) | ||
| RT2 | CHAR | (1) | ||
| RT3 | CHAR | (1) | ||
| RT4 | CHAR | (1) | ||
| RT5 | CHAR | (1) | ||
| RT6 | CHAR | (1) | ||
| RT7 | CHAR | (1) | ||
| RT8 | CHAR | (1) | ||
| RT9 | CHAR | (1) | ||
| RT10 | CHAR | (1) | ||
| RLKL | VARCHAR2 | (80) | ||
| RIMP | VARCHAR2 | (80) | ||
| RMAT | VARCHAR2 | (1) | ||
| RMVA | NUMBER | |||
| RAPP | VARCHAR2 | (80) | ||
| RCLASS | VARCHAR2 | (80) | ||
| CNM | VARCHAR2 | (240) | ||
| RC | CHAR | (0) | ||
| CDS | VARCHAR2 | (4000) | ||
| APN | VARCHAR2 | (240) | ||
| ADE | VARCHAR2 | (30) | ||
| AOE | VARCHAR2 | (30) | ||
| CAPP | VARCHAR2 | (80) | ||
| CLOC | VARCHAR2 | (80) | ||
| CTYP | VARCHAR2 | (80) | ||
| CAUT | VARCHAR2 | (80) | ||
| CAPL | VARCHAR2 | (50) | ||
| CSRC | VARCHAR2 | (240) | ||
| CPEV | VARCHAR2 | (240) | ||
| CBGR | VARCHAR2 | (240) | ||
| CJOB | VARCHAR2 | (700) | ||
| CPRV | VARCHAR2 | (1) | ||
| CDET | VARCHAR2 | (1) | ||
| CDIS | VARCHAR2 | (1) | ||
| CKEY | VARCHAR2 | (1) | ||
| CVSO | VARCHAR2 | (80) | ||
| CVNM | VARCHAR2 | (240) | ||
| CVIN | VARCHAR2 | (2000) | ||
| CCLASS | VARCHAR2 | (80) | ||
| CCM1 | CHAR | (1) | ||
| CCM2 | CHAR | (1) | ||
| CCM3 | CHAR | (1) | ||
| CCM4 | CHAR | (1) | ||
| CCM5 | CHAR | (1) | ||
| CCM6 | CHAR | (1) | ||
| CCM7 | CHAR | (1) | ||
| CCM8 | CHAR | (1) | ||
| CCM9 | CHAR | (1) | ||
| CCM10 | CHAR | (1) | ||
| CCT1 | CHAR | (1) | ||
| CCT2 | CHAR | (1) | ||
| CCT3 | CHAR | (1) | ||
| CCT4 | CHAR | (1) | ||
| CCT5 | CHAR | (1) | ||
| CCT6 | CHAR | (1) | ||
| CCT7 | CHAR | (1) | ||
| CCT8 | CHAR | (1) | ||
| CCT9 | CHAR | (1) | ||
| CCT10 | CHAR | (1) | ||
| CAS1 | CHAR | (1) | ||
| CAS2 | CHAR | (1) | ||
| CAS3 | CHAR | (1) | ||
| CAS4 | CHAR | (1) | ||
| CAS5 | CHAR | (1) | ||
| CAS6 | CHAR | (1) | ||
| CAS7 | CHAR | (1) | ||
| CAS8 | CHAR | (1) | ||
| CAS9 | CHAR | (1) | ||
| CAS10 | CHAR | (1) | ||
| UOM_CODE | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT CTX
, PPID
, PPN
, PDN
, PCDE
, PID
, PON
, POD
, RNM
, RID
, RR
, RDS
, RT1
, RT2
, RT3
, RT4
, RT5
, RT6
, RT7
, RT8
, RT9
, RT10
, RLKL
, RIMP
, RMAT
, RMVA
, RAPP
, RCLASS
, CNM
, RC
, CDS
, APN
, ADE
, AOE
, CAPP
, CLOC
, CTYP
, CAUT
, CAPL
, CSRC
, CPEV
, CBGR
, CJOB
, CPRV
, CDET
, CDIS
, CKEY
, CVSO
, CVNM
, CVIN
, CCLASS
, CCM1
, CCM2
, CCM3
, CCM4
, CCM5
, CCM6
, CCM7
, CCM8
, CCM9
, CCM10
, CCT1
, CCT2
, CCT3
, CCT4
, CCT5
, CCT6
, CCT7
, CCT8
, CCT9
, CCT10
, CAS1
, CAS2
, CAS3
, CAS4
, CAS5
, CAS6
, CAS7
, CAS8
, CAS9
, CAS10
, UOM_CODE
FROM APPS.AMW_BASIC_RCM_V;
APPS
AMW_AP_ASSOCIATIONS
AMW_ASSESSMENT_COMPONENTS
AMW_AUDIT_PROCEDURES_B
AMW_AUDIT_PROCEDURES_TL
AMW_CONTROLS_B
AMW_CONTROLS_TL
AMW_CONTROL_ASSERTIONS
AMW_CONTROL_ASSOCIATIONS
AMW_CONTROL_OBJECTIVES
AMW_LOOKUPS
AMW_OBJECTIVE_ASSOCIATIONS
AMW_OBJ_CLASSIFICATION_V
AMW_PROCESS
AMW_PROCESS_NAMES_TL
AMW_PROCESS_OBJECTIVES_B
AMW_PROCESS_OBJECTIVES_TL
AMW_PROC_HIERARCHY_DENORM
AMW_RISKS_B
AMW_RISKS_TL
AMW_RISK_ASSOCIATIONS
AMW_RISK_TYPE
FND_APPLICATION
PER_BUSINESS_GROUPS
PER_JOBS
APPS
AMW_EXPORT_RCM_V
|
|
|
|