VIEW: PA.PA_PROJECT_ASSET_LINES_ALL#

Source

View Text - Preformatted

select PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID, DESCRIPTION DESCRIPTION, PROJECT_ASSET_ID PROJECT_ASSET_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, CIP_CCID CIP_CCID, ASSET_COST_CCID ASSET_COST_CCID, ORIGINAL_ASSET_COST ORIGINAL_ASSET_COST, CURRENT_ASSET_COST CURRENT_ASSET_COST, PROJECT_ASSET_LINE_DETAIL_ID PROJECT_ASSET_LINE_DETAIL_ID, GL_DATE GL_DATE, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON, AMORTIZE_FLAG AMORTIZE_FLAG, NEW_MASTER_FLAG NEW_MASTER_FLAG, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REV_PROJ_ASSET_LINE_ID REV_PROJ_ASSET_LINE_ID, REV_FROM_PROJ_ASSET_LINE_ID REV_FROM_PROJ_ASSET_LINE_ID, ORG_ID ORG_ID, INVOICE_NUMBER INVOICE_NUMBER, VENDOR_NUMBER VENDOR_NUMBER, PO_VENDOR_ID PO_VENDOR_ID, PO_NUMBER PO_NUMBER, INVOICE_DATE INVOICE_DATE, INVOICE_CREATED_BY INVOICE_CREATED_BY, INVOICE_UPDATED_BY INVOICE_UPDATED_BY, INVOICE_ID INVOICE_ID, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER, ORIGINAL_ASSET_ID ORIGINAL_ASSET_ID, CAPITAL_EVENT_ID CAPITAL_EVENT_ID, FA_PERIOD_NAME FA_PERIOD_NAME, LINE_TYPE LINE_TYPE, RET_ADJUSTMENT_TXN_ID RET_ADJUSTMENT_TXN_ID, RETIREMENT_COST_TYPE RETIREMENT_COST_TYPE, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID from "PA"."PA_PROJECT_ASSET_LINES_ALL"

View Text - HTML Formatted

SELECT PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID
, DESCRIPTION DESCRIPTION
, PROJECT_ASSET_ID PROJECT_ASSET_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, CIP_CCID CIP_CCID
, ASSET_COST_CCID ASSET_COST_CCID
, ORIGINAL_ASSET_COST ORIGINAL_ASSET_COST
, CURRENT_ASSET_COST CURRENT_ASSET_COST
, PROJECT_ASSET_LINE_DETAIL_ID PROJECT_ASSET_LINE_DETAIL_ID
, GL_DATE GL_DATE
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, AMORTIZE_FLAG AMORTIZE_FLAG
, NEW_MASTER_FLAG NEW_MASTER_FLAG
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REV_PROJ_ASSET_LINE_ID REV_PROJ_ASSET_LINE_ID
, REV_FROM_PROJ_ASSET_LINE_ID REV_FROM_PROJ_ASSET_LINE_ID
, ORG_ID ORG_ID
, INVOICE_NUMBER INVOICE_NUMBER
, VENDOR_NUMBER VENDOR_NUMBER
, PO_VENDOR_ID PO_VENDOR_ID
, PO_NUMBER PO_NUMBER
, INVOICE_DATE INVOICE_DATE
, INVOICE_CREATED_BY INVOICE_CREATED_BY
, INVOICE_UPDATED_BY INVOICE_UPDATED_BY
, INVOICE_ID INVOICE_ID
, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME
, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER
, ORIGINAL_ASSET_ID ORIGINAL_ASSET_ID
, CAPITAL_EVENT_ID CAPITAL_EVENT_ID
, FA_PERIOD_NAME FA_PERIOD_NAME
, LINE_TYPE LINE_TYPE
, RET_ADJUSTMENT_TXN_ID RET_ADJUSTMENT_TXN_ID
, RETIREMENT_COST_TYPE RETIREMENT_COST_TYPE
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
FROM "PA"."PA_PROJECT_ASSET_LINES_ALL"