[Home] [Help]
View: PAYBV_COST
Product: | PAY - Payroll |
Description: | Discoverer base view for pay_costs. |
Implementation/DBA Data: |
APPS.PAYBV_COST
|
View Text
SELECT PC.COSTED_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('DEBIT_CREDIT'
, PC.DEBIT_OR_CREDIT) DEBIT_OR_CREDIT
, HR_BIS.BIS_DECODE_LOOKUP('BALANCE_COST'
, PC.BALANCE_OR_COST) BALANCE_OR_COST
, PC.DEBIT_OR_CREDIT DEBIT_OR_CREDIT_CODE
, PC.BALANCE_OR_COST BALANCE_OR_COST_CODE
, PC.COST_ID
, PC.ASSIGNMENT_ACTION_ID
, PC.INPUT_VALUE_ID
, PC.RUN_RESULT_ID
, PC.COST_ALLOCATION_KEYFLEX_ID
, PC.DISTRIBUTED_INPUT_VALUE_ID
, PC.DISTRIBUTED_RUN_RESULT_ID
, PC.SOURCE_ID
FROM PAY_COSTS PC WITH READ ONLY
Columns
Name |
COSTED_VALUE |
DEBIT_OR_CREDIT |
BALANCE_OR_COST |
DEBIT_OR_CREDIT_CODE |
BALANCE_OR_COST_CODE |
COST_ID |
ASSIGNMENT_ACTION_ID |
INPUT_VALUE_ID |
RUN_RESULT_ID |
COST_ALLOCATION_KEYFLEX_ID |
DISTRIBUTED_INPUT_VALUE_ID |
DISTRIBUTED_RUN_RESULT_ID |
SOURCE_ID |