[Home] [Help]
View: PA_BUDGET_ENTRY_METHODS_V
Product: | PA - Projects |
Description: | This view displays the valid budget entry methods which control how a budget is entered |
Implementation/DBA Data: |
APPS.PA_BUDGET_ENTRY_METHODS_V
|
View Text
SELECT PBEM.BUDGET_ENTRY_METHOD_CODE
, PBEM.BUDGET_ENTRY_METHOD
, PBEM.ENTRY_LEVEL_CODE
, PL1.MEANING
, PBEM.CATEGORIZATION_CODE
, PBEM.COST_QUANTITY_FLAG
, PBEM.RAW_COST_FLAG
, PBEM.BURDENED_COST_FLAG
, PBEM.REV_QUANTITY_FLAG
, PBEM.REVENUE_FLAG
, PBEM.TIME_PHASED_TYPE_CODE
, PL2.MEANING
FROM PA_BUDGET_ENTRY_METHODS PBEM
, PA_LOOKUPS PL1
, PA_LOOKUPS PL2
WHERE PL1.LOOKUP_TYPE = 'BUDGET ENTRY LEVEL'
AND PBEM.ENTRY_LEVEL_CODE = PL1.LOOKUP_CODE
AND PL2.LOOKUP_TYPE = 'BUDGET TIME PHASED TYPE'
AND PBEM.TIME_PHASED_TYPE_CODE = PL2.LOOKUP_CODE
AND TRUNC(SYSDATE) BETWEEN PBEM.START_DATE_ACTIVE
AND NVL(PBEM.END_DATE_ACTIVE
, TRUNC(SYSDATE))
Columns
Name |
CODE |
NAME |
ENTRY_LEVEL_CODE |
ENTRY_LEVEL_NAME |
CATEGORIZATION_CODE |
COST_QUANTITY_FLAG |
RAW_COST_FLAG |
BURDENED_COST_FLAG |
REV_QUANTITY_FLAG |
REVENUE_FLAG |
TIME_PHASED_TYPE_CODE |
TIME_PHASED_TYPE_NAME |