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


VIEW: APPS.AMW_BASIC_RCM_V

Object Details
Object Name: AMW_BASIC_RCM_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.AMW_BASIC_RCM_V references the following:

SchemaAPPS
SynonymAMW_AP_ASSOCIATIONS
SynonymAMW_ASSESSMENT_COMPONENTS
SynonymAMW_AUDIT_PROCEDURES_B
SynonymAMW_AUDIT_PROCEDURES_TL
SynonymAMW_CONTROLS_B
SynonymAMW_CONTROLS_TL
SynonymAMW_CONTROL_ASSERTIONS
SynonymAMW_CONTROL_ASSOCIATIONS
SynonymAMW_CONTROL_OBJECTIVES
ViewAMW_LOOKUPS
SynonymAMW_OBJECTIVE_ASSOCIATIONS
ViewAMW_OBJ_CLASSIFICATION_V
SynonymAMW_PROCESS
SynonymAMW_PROCESS_NAMES_TL
SynonymAMW_PROCESS_OBJECTIVES_B
SynonymAMW_PROCESS_OBJECTIVES_TL
SynonymAMW_PROC_HIERARCHY_DENORM
SynonymAMW_RISKS_B
SynonymAMW_RISKS_TL
SynonymAMW_RISK_ASSOCIATIONS
SynonymAMW_RISK_TYPE
SynonymFND_APPLICATION
ViewPER_BUSINESS_GROUPS
SynonymPER_JOBS
APPS.AMW_BASIC_RCM_V is referenced by following:

SchemaAPPS
ViewAMW_EXPORT_RCM_V