VIEW: APPS.PA_ASSET_LINE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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