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


VIEW: APPS.PA_IND_RATE_SCHEDULES

Object Details
Object Name: PA_IND_RATE_SCHEDULES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_IND_RATE_SCHEDULES
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View of all burden schedules owned by the business group.PA_IND_RATE_SCHEDULES is a view that displays all burden schedules owned by the business group specified in PA_IMPLEMENTATIONS_ALL.


[View Source]

Columns
Name Datatype Length Mandatory Comments
IND_RATE_SCH_ID NUMBER (15) Yes Refer to base table.
IND_RATE_SCH_NAME VARCHAR2 (30) Yes Refer to base table.
DESCRIPTION VARCHAR2 (250)
Refer to base table.
START_DATE_ACTIVE DATE
Yes Refer to base table.
END_DATE_ACTIVE DATE

Refer to base table.
LAST_UPDATE_DATE DATE
Yes Refer to base table.
LAST_UPDATED_BY NUMBER (15) Yes Refer to base table.
CREATED_BY NUMBER (15) Yes Refer to base table.
CREATION_DATE DATE
Yes Refer to base table.
LAST_UPDATE_LOGIN NUMBER (15) Yes Refer to base table.
COST_PLUS_STRUCTURE VARCHAR2 (30) Yes Refer to base table.
IND_RATE_SCHEDULE_TYPE VARCHAR2 (1) Yes Refer to base table.
PROJECT_ID NUMBER (15)
Refer to base table.
TASK_ID NUMBER (15)
Refer to base table.
COST_OVR_SCH_FLAG VARCHAR2 (1)
Refer to base table.
REV_OVR_SCH_FLAG VARCHAR2 (1)
Refer to base table.
INV_OVR_SCH_FLAG VARCHAR2 (1)
Refer to base table.
BUSINESS_GROUP_ID NUMBER (15) Yes Refer to base table.
ORGANIZATION_STRUCTURE_ID NUMBER (15) Yes Refer to base table.
ORG_STRUCTURE_VERSION_ID NUMBER (15) Yes Refer to base table.
START_ORGANIZATION_ID NUMBER (15) Yes Refer to base table.
IND_RATE_SCH_USAGE VARCHAR2 (30) Yes Refer to base table.
Query Text

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


SELECT IND_RATE_SCH_ID
,      IND_RATE_SCH_NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      COST_PLUS_STRUCTURE
,      IND_RATE_SCHEDULE_TYPE
,      PROJECT_ID
,      TASK_ID
,      COST_OVR_SCH_FLAG
,      REV_OVR_SCH_FLAG
,      INV_OVR_SCH_FLAG
,      BUSINESS_GROUP_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      START_ORGANIZATION_ID
,      IND_RATE_SCH_USAGE
FROM APPS.PA_IND_RATE_SCHEDULES;

Dependencies

[top of page]

APPS.PA_IND_RATE_SCHEDULES references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymPA_IND_RATE_SCHEDULES_ALL_BG
PL/SQL PackagePA_UTILS - show dependent code
APPS.PA_IND_RATE_SCHEDULES is referenced by following:

SchemaAPPS
ViewGMS_AWARDS_V
Package BodyGMS_AWARD_PUB - show dependent code
Package BodyGMS_AWARD_PVT - show dependent code
ViewGMS_OVERRIDE_SCHEDULES_V
Package BodyPA_BILLING_SCHEDULE_UTILS - show dependent code
ViewPA_CC_TP_RULES_V
Package BodyPA_COST - show dependent code
Package BodyPA_COST1 - show dependent code
Package BodyPA_COST_PLUS - show dependent code
PL/SQL PackagePA_COST_PLUS - show dependent code
Package BodyPA_COST_PLUS1 - show dependent code
Package BodyPA_COST_PLUS_STRUCTURE_PKG - show dependent code
Package BodyPA_FORECAST_COST - show dependent code
Package BodyPA_FUNDS_CONTROL_PKG1 - show dependent code
Package BodyPA_FUNDS_CONTROL_UTILS - show dependent code
ViewPA_INVOICE_SCHEDULES_LOV_V
Package BodyPA_PROJECT_CHECK_PVT - show dependent code
Package BodyPA_PROJECT_CORE - show dependent code
Package BodyPA_PROJECT_CORE1 - show dependent code
Package BodyPA_PROJECT_CORE2 - show dependent code
Package BodyPA_PROJECT_PUB - show dependent code
Package BodyPA_PROJECT_PVT - show dependent code
Package BodyPA_PROJ_TSK_UTILS - show dependent code
ViewPA_REVENUE_SCHEDULES_LOV_V