Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROJECT_ASSET_LINE_ID
, DESCRIPTION
, PROJECT_ASSET_ID
, PROJECT_ID
, TASK_ID
, CIP_CCID
, ASSET_COST_CCID
, ORIGINAL_ASSET_COST
, CURRENT_ASSET_COST
, PROJECT_ASSET_LINE_DETAIL_ID
, GL_DATE
, TRANSFER_STATUS_CODE
, TRANSFER_REJECTION_REASON
, AMORTIZE_FLAG
, NEW_MASTER_FLAG
, ASSET_CATEGORY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REV_PROJ_ASSET_LINE_ID
, REV_FROM_PROJ_ASSET_LINE_ID
, INVOICE_NUMBER
, VENDOR_NUMBER
, PO_VENDOR_ID
, PO_NUMBER
, INVOICE_DATE
, INVOICE_CREATED_BY
, INVOICE_UPDATED_BY
, INVOICE_ID
, PAYABLES_BATCH_NAME
, AP_DISTRIBUTION_LINE_NUMBER
, ORIGINAL_ASSET_ID
, ORG_ID
, LINE_TYPE
, CAPITAL_EVENT_ID
, FA_PERIOD_NAME
, RET_ADJUSTMENT_TXN_ID
, RETIREMENT_COST_TYPE
FROM PA_PROJECT_ASSET_LINES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)