[Home] [Help]
View: PA_CINT_EXP_TYPE_EXCL
Product: | PA - Projects |
Description: | This is a single org view created for Form |
Implementation/DBA Data: |
APPS.PA_CINT_EXP_TYPE_EXCL
|
View Text
SELECT EXP.ROWID
, EXP.IND_COST_CODE
, EXP.EXPENDITURE_TYPE
, TYPE.EXPENDITURE_CATEGORY
, EXP.CREATION_DATE
, EXP.CREATED_BY
, EXP.LAST_UPDATE_DATE
, EXP.LAST_UPDATED_BY
, EXP.LAST_UPDATE_LOGIN
, EXP.ORG_ID
FROM PA_CINT_EXP_TYPE_EXCL_ALL EXP
, PA_EXPENDITURE_TYPES TYPE
WHERE TYPE.EXPENDITURE_TYPE = EXP.EXPENDITURE_TYPE
AND EXP.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
Columns
Name |
ROW_ID |
IND_COST_CODE |
EXPENDITURE_TYPE |
EXPENDITURE_CATEGORY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ORG_ID |