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