[Home] [Help] [Dependency Information]
Object Name: | CSP_PLAN_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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) |
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;
APPS.CSP_PLAN_DETAILS_V is not referenced by any database object
|
|
|