FND Design Data [Home] [Help]

View: PAYBV_COST

Product: PAY - Payroll
Description: Discoverer base view for pay_costs.
Implementation/DBA Data: ViewAPPS.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