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


VIEW: APPS.CHV_ORG_OPTIONS_V

Object Details
Object Name: CHV_ORG_OPTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCHV.CHV_ORG_OPTIONS_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)
Rowid
SHIP_TO_ORGANIZATION_ID NUMBER
Yes Ship-to organization unique identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship-to organization code
SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240)
Ship-to organization name
ENABLE_CUM_FLAG VARCHAR2 (1) Yes CUM tracking enabled
RTV_UPDATE_CUM_FLAG VARCHAR2 (1) Yes RTV transactions included in CUM.
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
PLAN_BUCKET_PATTERN_ID NUMBER

Default plan schedule bucket pattern
PLAN_BUCKET_PATTERN_NAME VARCHAR2 (25)
Planning schedule bucket pattern name
SHIP_BUCKET_PATTERN_ID NUMBER

Default ship schedule bucket pattern
SHIP_BUCKET_PATTERN_NAME VARCHAR2 (25)
Shipping schedule bucket pattern name
PLAN_SCHEDULE_TYPE VARCHAR2 (25)
Default plan schedule sub-type
PLAN_SCHEDULE_TYPE_NAME VARCHAR2 (80)
Planning schedule subtype name
SHIP_SCHEDULE_TYPE VARCHAR2 (25)
Default ship schedule sub-type
SHIP_SCHEDULE_TYPE_NAME VARCHAR2 (80)
Shipping schedule subtype name
MRP_COMPILE_DESIGNATOR VARCHAR2 (10)
Default MRP plan
MRP_COMPILE_DESIGNATOR_DESC VARCHAR2 (50)
MRP Name
MPS_SCHEDULE_DESIGNATOR VARCHAR2 (10)
Default MPS plan
MPS_SCHEDULE_DESIGNATOR_DESC VARCHAR2 (50)
MPS name
DRP_COMPILE_DESIGNATOR VARCHAR2 (10)
Default DRP plan
DRP_COMPILE_DESIGNATOR_DESC VARCHAR2 (50)
DRP name
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
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
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
Query Text

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


SELECT ROW_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      ENABLE_CUM_FLAG
,      RTV_UPDATE_CUM_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PLAN_BUCKET_PATTERN_ID
,      PLAN_BUCKET_PATTERN_NAME
,      SHIP_BUCKET_PATTERN_ID
,      SHIP_BUCKET_PATTERN_NAME
,      PLAN_SCHEDULE_TYPE
,      PLAN_SCHEDULE_TYPE_NAME
,      SHIP_SCHEDULE_TYPE
,      SHIP_SCHEDULE_TYPE_NAME
,      MRP_COMPILE_DESIGNATOR
,      MRP_COMPILE_DESIGNATOR_DESC
,      MPS_SCHEDULE_DESIGNATOR
,      MPS_SCHEDULE_DESIGNATOR_DESC
,      DRP_COMPILE_DESIGNATOR
,      DRP_COMPILE_DESIGNATOR_DESC
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.CHV_ORG_OPTIONS_V;

Dependencies

[top of page]

APPS.CHV_ORG_OPTIONS_V references the following:

SchemaAPPS
SynonymCHV_BUCKET_PATTERNS
SynonymCHV_ORG_OPTIONS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMRP_DESIGNATORS
SynonymMRP_PLANS
SynonymMTL_PARAMETERS
ViewPO_LOOKUP_CODES

APPS.CHV_ORG_OPTIONS_V is not referenced by any database object