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

VIEW: APPS.PAY_COSTING_PROJECTS_V

Object Details
Object Name: PAY_COSTING_PROJECTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
COST_TYPE VARCHAR2 (12)
EFFECTIVE_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
CONSOLIDATION_SET_NAME VARCHAR2 (60) Yes
PAYROLL_NAME VARCHAR2 (80) Yes
ORGANIZATION_NAME VARCHAR2 (240) Yes
LOCATION_CODE VARCHAR2 (60)
FULL_NAME VARCHAR2 (240)
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Yes
MIDDLE_NAMES VARCHAR2 (60)
EMPLOYEE_NUMBER VARCHAR2 (30)
NATIONAL_IDENTIFIER VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
ELEMENT_NAME VARCHAR2 (80) Yes
REPORTING_NAME VARCHAR2 (80)
CLASSIFICATION_NAME_TL VARCHAR2 (80) Yes
CLASSIFICATION_NAME VARCHAR2 (80) Yes
INPUT_VALUE_NAME VARCHAR2 (80) Yes
UOM VARCHAR2 (4000)
OUTPUT_CURRENCY_CODE VARCHAR2 (15)
CREDIT_AMOUNT NUMBER

DEBIT_AMOUNT NUMBER

CONCATENATED_SEGMENTS VARCHAR2 (2000)
SEGMENT1 VARCHAR2 (60)
SEGMENT2 VARCHAR2 (60)
SEGMENT3 VARCHAR2 (60)
SEGMENT4 VARCHAR2 (60)
SEGMENT5 VARCHAR2 (60)
SEGMENT6 VARCHAR2 (60)
SEGMENT7 VARCHAR2 (60)
SEGMENT8 VARCHAR2 (60)
SEGMENT9 VARCHAR2 (60)
SEGMENT10 VARCHAR2 (60)
SEGMENT11 VARCHAR2 (60)
SEGMENT12 VARCHAR2 (60)
SEGMENT13 VARCHAR2 (60)
SEGMENT14 VARCHAR2 (60)
SEGMENT15 VARCHAR2 (60)
SEGMENT16 VARCHAR2 (60)
SEGMENT17 VARCHAR2 (60)
SEGMENT18 VARCHAR2 (60)
SEGMENT19 VARCHAR2 (60)
SEGMENT20 VARCHAR2 (60)
SEGMENT21 VARCHAR2 (60)
SEGMENT22 VARCHAR2 (60)
SEGMENT23 VARCHAR2 (60)
SEGMENT24 VARCHAR2 (60)
SEGMENT25 VARCHAR2 (60)
SEGMENT26 VARCHAR2 (60)
SEGMENT27 VARCHAR2 (60)
SEGMENT28 VARCHAR2 (60)
SEGMENT29 VARCHAR2 (60)
SEGMENT30 VARCHAR2 (60)
PAYROLL_ACTION_ID NUMBER (9) Yes
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
CONSOLIDATION_SET_ID NUMBER (9) Yes
PAYROLL_ID NUMBER (9) Yes
TAX_UNIT_ID NUMBER

ORGANIZATION_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15)
PERSON_ID NUMBER (10) Yes
ASSIGNMENT_ID NUMBER (10) Yes
CLASSIFICATION_ID NUMBER (9) Yes
ELEMENT_TYPE_ID NUMBER (9) Yes
INPUT_VALUE_ID NUMBER (9) Yes
RUN_RESULT_ID NUMBER (15)
GRE_NAME VARCHAR2 (4000)
COST_ID NUMBER (15) Yes
TRANSFERED_TO_PRJ VARCHAR2 (30)
TIME_PERIOD_ID NUMBER (15) Yes
TIME_PERIOD_START_DATE DATE
Yes
TIME_PERIOD_END_DATE DATE
Yes
SOURCE_CREATOR_TYPE VARCHAR2 (30) Yes
SOURCE_START_DATE DATE

SOURCE_END_DATE DATE

BALANCE_OR_COST VARCHAR2 (30) Yes
Query Text

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


SELECT COST_TYPE
,      EFFECTIVE_DATE
,      BUSINESS_GROUP_ID
,      CONSOLIDATION_SET_NAME
,      PAYROLL_NAME
,      ORGANIZATION_NAME
,      LOCATION_CODE
,      FULL_NAME
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAMES
,      EMPLOYEE_NUMBER
,      NATIONAL_IDENTIFIER
,      ASSIGNMENT_NUMBER
,      ELEMENT_NAME
,      REPORTING_NAME
,      CLASSIFICATION_NAME_TL
,      CLASSIFICATION_NAME
,      INPUT_VALUE_NAME
,      UOM
,      OUTPUT_CURRENCY_CODE
,      CREDIT_AMOUNT
,      DEBIT_AMOUNT
,      CONCATENATED_SEGMENTS
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      CONSOLIDATION_SET_ID
,      PAYROLL_ID
,      TAX_UNIT_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      CLASSIFICATION_ID
,      ELEMENT_TYPE_ID
,      INPUT_VALUE_ID
,      RUN_RESULT_ID
,      GRE_NAME
,      COST_ID
,      TRANSFERED_TO_PRJ
,      TIME_PERIOD_ID
,      TIME_PERIOD_START_DATE
,      TIME_PERIOD_END_DATE
,      SOURCE_CREATOR_TYPE
,      SOURCE_START_DATE
,      SOURCE_END_DATE
,      BALANCE_OR_COST
FROM APPS.PAY_COSTING_PROJECTS_V;

Dependencies

[top of page]

APPS.PAY_COSTING_PROJECTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_CONSOLIDATION_SETS
PL/SQL PackagePAY_COSTING_DETAIL_REP_PKG - show dependent code
SynonymPAY_COSTS
SynonymPAY_COST_ALLOCATION_KEYFLEX
SynonymPAY_ELEMENT_CLASSIFICATIONS
SynonymPAY_ELEMENT_CLASSIFICATIONS_TL
SynonymPAY_ELEMENT_ENTRIES_F
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_ELEMENT_TYPES_F_TL
SynonymPAY_INPUT_VALUES_F
SynonymPAY_INPUT_VALUES_F_TL
ViewPAY_PAYROLLS_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_RUN_RESULTS
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F
SynonymPER_TIME_PERIODS
APPS.PAY_COSTING_PROJECTS_V is referenced by following:

SchemaAPPS
Package BodyPA_PAY_INTERFACE - show dependent code
Package BodyPA_REVERSE_COSTED_LAB - show dependent code