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


VIEW: APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V

Object Details
Object Name: PSB_WS_DISTRIBUTE_RULE_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_WS_DISTRIBUTE_RULE_LINES_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)
BUDGET_GROUP_ID NUMBER (20)
NAME VARCHAR2 (80)
PARENT_BUDGET_GROUP_ID NUMBER (20)
PARENT_NAME VARCHAR2 (80)
ROOT_BUDGET_GROUP_ID NUMBER (20)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

DISTRIBUTION_RULE_LINE_ID NUMBER (15)
DISTRIBUTION_RULE_ID NUMBER (15)
DISTRIBUTE_FLAG VARCHAR2 (1)
DISTRIBUTE_ALL_LEVEL_FLAG VARCHAR2 (1)
DOWNLOAD_FLAG VARCHAR2 (1)
DOWNLOAD_ALL_LEVEL_FLAG VARCHAR2 (1)
YEAR_CATEGORY_TYPE VARCHAR2 (10)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
CONTEXT VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      BUDGET_GROUP_ID
,      NAME
,      PARENT_BUDGET_GROUP_ID
,      PARENT_NAME
,      ROOT_BUDGET_GROUP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      DISTRIBUTION_RULE_LINE_ID
,      DISTRIBUTION_RULE_ID
,      DISTRIBUTE_FLAG
,      DISTRIBUTE_ALL_LEVEL_FLAG
,      DOWNLOAD_FLAG
,      DOWNLOAD_ALL_LEVEL_FLAG
,      YEAR_CATEGORY_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
FROM APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V;

Dependencies

[top of page]

APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V references the following:

SchemaAPPS
ViewPSB_BUDGET_GROUPS_V
PL/SQL PackagePSB_WS_DISTRIBUTION_RULES_PVT - show dependent code
SynonymPSB_WS_DISTRIBUTION_RULE_LINES

APPS.PSB_WS_DISTRIBUTE_RULE_LINES_V is not referenced by any database object