Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: |
![]() |
SELECT PROJECT_ASSET_LINE_ID
, ORIGINAL_ASSET_COST
, CURRENT_ASSET_COST
, DESCRIPTION
, GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, TRANSFER_REJECTION_REASON
, '_LA:AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PROJECT_ASSET_ID
, TASK_ID
, ASSET_CATEGORY_ID
, CIP_CCID
, REV_PROJ_ASSET_LINE_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, INVOICE_ID
FROM PA_PROJECT_ASSET_LINES_ALL
WHERE '_SEC:ORG_ID' IS NOT NULL WITH READ ONLY