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


VIEW: APPS.CSP_PLAN_DETAILS_V

Object Details
Object Name: CSP_PLAN_DETAILS_V
Object Type: VIEW
Owner: APPS
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
PAST NUMBER

CURR NUMBER

C1 NUMBER

C2 NUMBER

C3 NUMBER

C4 NUMBER

C5 NUMBER

C6 NUMBER

C7 NUMBER

C8 NUMBER

C9 NUMBER

C10 NUMBER

C11 NUMBER

C12 NUMBER

C13 NUMBER

C14 NUMBER

C15 NUMBER

C16 NUMBER

C17 NUMBER

C18 NUMBER

C19 NUMBER

C20 NUMBER

C21 NUMBER

C22 NUMBER

C23 NUMBER

C24 NUMBER

C25 NUMBER

C26 NUMBER

C27 NUMBER

C28 NUMBER

C29 NUMBER

C30 NUMBER

C31 NUMBER

C32 NUMBER

C33 NUMBER

C34 NUMBER

C35 NUMBER

C36 NUMBER

C37 NUMBER

C38 NUMBER

C39 NUMBER

C40 NUMBER

C41 NUMBER

C42 NUMBER

C43 NUMBER

C44 NUMBER

C45 NUMBER

C46 NUMBER

C47 NUMBER

C48 NUMBER

C49 NUMBER

C50 NUMBER

C51 NUMBER

C52 NUMBER

PARENT_TYPE VARCHAR2 (30)
PLAN_DETAIL_TYPE VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
ITEM_NUMBER VARCHAR2 (40)
PLAN_DETAIL_TYPE_MEANING VARCHAR2 (541)
Query Text

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


SELECT PAST
,      CURR
,      C1
,      C2
,      C3
,      C4
,      C5
,      C6
,      C7
,      C8
,      C9
,      C10
,      C11
,      C12
,      C13
,      C14
,      C15
,      C16
,      C17
,      C18
,      C19
,      C20
,      C21
,      C22
,      C23
,      C24
,      C25
,      C26
,      C27
,      C28
,      C29
,      C30
,      C31
,      C32
,      C33
,      C34
,      C35
,      C36
,      C37
,      C38
,      C39
,      C40
,      C41
,      C42
,      C43
,      C44
,      C45
,      C46
,      C47
,      C48
,      C49
,      C50
,      C51
,      C52
,      PARENT_TYPE
,      PLAN_DETAIL_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_NUMBER
,      PLAN_DETAIL_TYPE_MEANING
FROM APPS.CSP_PLAN_DETAILS_V;

Dependencies

[top of page]

APPS.CSP_PLAN_DETAILS_V references the following:

SchemaAPPS
SynonymCSP_PLANNING_PARAMETERS
SynonymCSP_PLAN_DETAILS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CSP_PLAN_DETAILS_V is not referenced by any database object