VIEW: HR.PQH_GL_INTERFACE#

Source

View Text - Preformatted

select GL_INTERFACE_ID GL_INTERFACE_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, BUDGET_DETAIL_ID BUDGET_DETAIL_ID, PERIOD_NAME PERIOD_NAME, CODE_COMBINATION_ID CODE_COMBINATION_ID, POSTING_TYPE_CD POSTING_TYPE_CD, CURRENCY_CODE CURRENCY_CODE, AMOUNT_DR AMOUNT_DR, AMOUNT_CR AMOUNT_CR, ACCOUNTING_DATE ACCOUNTING_DATE, POSTING_DATE POSTING_DATE, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, STATUS STATUS, ADJUSTMENT_FLAG ADJUSTMENT_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, ORGANIZATION_ID ORGANIZATION_ID from "HR"."PQH_GL_INTERFACE"

View Text - HTML Formatted

SELECT GL_INTERFACE_ID GL_INTERFACE_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, PERIOD_NAME PERIOD_NAME
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, POSTING_TYPE_CD POSTING_TYPE_CD
, CURRENCY_CODE CURRENCY_CODE
, AMOUNT_DR AMOUNT_DR
, AMOUNT_CR AMOUNT_CR
, ACCOUNTING_DATE ACCOUNTING_DATE
, POSTING_DATE POSTING_DATE
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, STATUS STATUS
, ADJUSTMENT_FLAG ADJUSTMENT_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
FROM "HR"."PQH_GL_INTERFACE"