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

VIEW: APPS.PAY_COSTING_DETAILS_V

Object Details
Object Name: PAY_COSTING_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_COSTING_DETAILS_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
COST_TYPE VARCHAR2 (12)
Action Type in PAY_PAYROLL_ACTIONS table
EFFECTIVE_DATE DATE
Yes Effective Date
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group ID
CONSOLIDATION_SET_NAME VARCHAR2 (60) Yes Name of the consolidation set
PAYROLL_NAME VARCHAR2 (80) Yes Name of the payroll
ORGANIZATION_NAME VARCHAR2 (240) Yes Name of the organization
LOCATION_CODE VARCHAR2 (60) Yes Location code from HR_LOCATIONS
FULL_NAME VARCHAR2 (240)
Person full name
FIRST_NAME VARCHAR2 (150)
Person first name
LAST_NAME VARCHAR2 (150) Yes Person last name
MIDDLE_NAMES VARCHAR2 (60)
Person middle name
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
NATIONAL_IDENTIFIER VARCHAR2 (30)
National Identifier
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment Number
ELEMENT_NAME VARCHAR2 (80) Yes Name of the element
REPORTING_NAME VARCHAR2 (80)
Translated element name
INPUT_VALUE_NAME VARCHAR2 (80) Yes Input value name
UOM VARCHAR2 (4000)
Unit of measure
CREDIT_AMOUNT NUMBER

Credit amount
DEBIT_AMOUNT NUMBER

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

Tax Unit ID
ORGANIZATION_ID NUMBER (15) Yes Organization ID
LOCATION_ID NUMBER (15) Yes Location ID
PERSON_ID NUMBER (10) Yes Person ID
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
CLASSIFICATION_ID NUMBER (9) Yes Element classification ID
ELEMENT_TYPE_ID NUMBER (9) Yes Element Type ID
INPUT_VALUE_ID NUMBER (9) Yes Input value ID
RUN_RESULT_ID NUMBER (15)
Run result ID
GRE_NAME VARCHAR2 (240)
GRE name based on tax unit id
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
,      INPUT_VALUE_NAME
,      UOM
,      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
FROM APPS.PAY_COSTING_DETAILS_V;

Dependencies

[top of page]

APPS.PAY_COSTING_DETAILS_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_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_CONSOLIDATION_SETS
SynonymPAY_COSTS
SynonymPAY_COST_ALLOCATION_KEYFLEX
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_ELEMENT_TYPES_F_TL
SynonymPAY_INPUT_VALUES_F
SynonymPAY_INPUT_VALUES_F_TL
ViewPAY_PAYROLLS_F
SynonymPAY_PAYROLL_ACTIONS
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F
APPS.PAY_COSTING_DETAILS_V is referenced by following:

SchemaPUBLIC
SynonymPAY_COSTING_DETAILS_V