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


VIEW: APPS.QA_ERES_PLANS_V

Object Details
Object Name: QA_ERES_PLANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_ERES_PLANS_V
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
PLAN_ID NUMBER
Yes Collection plan identifier
ORGANIZATION_ID NUMBER
Yes Inventory Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
NAME VARCHAR2 (30) Yes Collection plan name
DESCRIPTION VARCHAR2 (150)
Collection plan description
PLAN_TYPE_CODE VARCHAR2 (30) Yes Collection plan type code
PLAN_TYPE_MEANING VARCHAR2 (80)
Collection plan type meaning
PLAN_TYPE_DESCRIPTION VARCHAR2 (240)
Collection plan type description
EFFECTIVE_FROM DATE

Date from which plan is effective
EFFECTIVE_TO DATE

Date upto which plan will be effective
SPEC_ASSIGNMENT_TYPE NUMBER
Yes Specification assignment type associated with this plan
SPEC_ASSIGNMENT_MEANING VARCHAR2 (80)
Specification assignement type meaning
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
TEMPLATE_PLAN_ID NUMBER

Template Collection Plan Identifier
JRAD_DOC_VER NUMBER

JRAD Document Version
ESIG_MODE VARCHAR2 (1)
eSignature mode (R - single row approval, C - collection approval)
ESIG_MODE_MEANING VARCHAR2 (80)
decode the meaning of esig_mode
ORGANIZATION_CODE VARCHAR2 (3)
org code
ORGANIZATION_NAME VARCHAR2 (240)
org name
Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      PLAN_TYPE_CODE
,      PLAN_TYPE_MEANING
,      PLAN_TYPE_DESCRIPTION
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      SPEC_ASSIGNMENT_TYPE
,      SPEC_ASSIGNMENT_MEANING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TEMPLATE_PLAN_ID
,      JRAD_DOC_VER
,      ESIG_MODE
,      ESIG_MODE_MEANING
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
FROM APPS.QA_ERES_PLANS_V;

Dependencies

[top of page]

APPS.QA_ERES_PLANS_V references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
ViewQA_LOOKUPS
SynonymQA_PLANS

APPS.QA_ERES_PLANS_V is not referenced by any database object