Product: | PA - Projects |
---|---|
Description: | Release 10SC Only |
Implementation/DBA Data: | APPS.PA_ASSET_LINE_DETAILS_V |
SELECT D.PROJECT_ASSET_LINE_DETAIL_ID
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, D.CIP_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, D.CIP_COST
, NULL)
, D.CIP_COST)
, NULL
, NULL
, NULL
, NULL
, NULL
, EI.ROW_ID
, EI.EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ID
, EI.PROJECT_ID
, EI.TASK_ID
, EI.TASK_NUMBER
, EI.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_CATEGORY
, EI.INCURRED_BY_PERSON_ID
, EI.EMPLOYEE_NAME
, EI.EMPLOYEE_NUMBER
, EI.JOB_ID
, EI.JOB_NAME
, EI.EXPENDITURE_ORGANIZATION_ID
, EI.EXPENDITURE_ORGANIZATION_NAME
, EI.VENDOR_ID
, EI.VENDOR_NAME
, EI.VENDOR_NUMBER
, EI.EMPLOYEE_VENDOR_NAME
, EI.EMPLOYEE_VENDOR_NUMBER
, EI.NON_LABOR_RESOURCE
, EI.NLR_ORGANIZATION_ID
, EI.NLR_ORGANIZATION_NAME
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.SYSTEM_LINKAGE_M
, EI.EXPENDITURE_COMMENT
, EI.USER_TRANSACTION_SOURCE
, EI.ORIG_TRANSACTION_REFERENCE
, EI.EXPENDITURE_GROUP
, EI.UNIT_OF_MEASURE
, EI.UNIT_OF_MEASURE_M
, EI.QUANTITY
, EI.RECEIPT_CURRENCY_CODE
, EI.RECEIPT_CURRENCY_AMOUNT
, EI.RECEIPT_EXCHANGE_RATE
, EI.DENOM_CURRENCY_CODE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.DENOM_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.DENOM_RAW_COST
, NULL)
, EI.DENOM_RAW_COST)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.DENOM_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.DENOM_BURDENED_COST
, NULL)
, EI.DENOM_BURDENED_COST)
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_TYPE
, EI.USER_ACCT_RATE_TYPE
, EI.ACCT_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.ACCT_RAW_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.ACCT_RAW_COST
, NULL)
, EI.ACCT_RAW_COST)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.ACCT_BURDENED_COST
, NULL)
, 'OT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(EI.PROJECT_ID)
, 'Y'
, EI.ACCT_BURDENED_COST
, NULL)
, EI.ACCT_BURDENED_COST)
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_TYPE
, EI.USER_PROJECT_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_EXCHANGE_RATE
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATE_LOGIN
, EI.LAST_UPDATED_BY
, EI.CREATION_DATE
, EI.CREATED_BY
, EI.ATTRIBUTE_CATEGORY
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PA_EXPEND_ITEMS_ADJUST_V EI
, PA_PROJECT_ASSET_LINE_DETAILS D
WHERE EI.EXPENDITURE_ITEM_ID = D.EXPENDITURE_ITEM_ID