eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

APPS: CSP_PLANNING_PARAMETERS; CSP_PLAN_DETAILS; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_ALL_ORGANIZATION_UNITS; MTL_SYSTEM_ITEMS_KFV

APPS.CSP_PLAN_DETAILS_V is not referenced by any database object