VIEW: IGI.IGI_RPI_LINE_DETAILS_ALL#

Source

View Text - Preformatted

select STANDING_CHARGE_ID STANDING_CHARGE_ID, LINE_ITEM_ID LINE_ITEM_ID, CHARGE_ITEM_NUMBER CHARGE_ITEM_NUMBER, ITEM_ID ITEM_ID, PRICE PRICE, QUANTITY QUANTITY, PERIOD_NAME PERIOD_NAME, CURRENT_EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PREVIOUS_EFFECTIVE_DATE PREVIOUS_EFFECTIVE_DATE, DESCRIPTION DESCRIPTION, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, START_DATE START_DATE, DURATION DURATION, REVISED_EFFECTIVE_DATE REVISED_EFFECTIVE_DATE, REVISED_PRICE REVISED_PRICE, PREVIOUS_PRICE PREVIOUS_PRICE, VAT_TAX_ID VAT_TAX_ID, REVENUE_CODE_COMBINATION_ID REVENUE_CODE_COMBINATION_ID, RECEIVABLE_CODE_COMBINATION_ID RECEIVABLE_CODE_COMBINATION_ID, ORG_ID ORG_ID, RUN_ID RUN_ID, ADDITIONAL_REFERENCE ADDITIONAL_REFERENCE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "IGI"."IGI_RPI_LINE_DETAILS_ALL"

View Text - HTML Formatted

SELECT STANDING_CHARGE_ID STANDING_CHARGE_ID
, LINE_ITEM_ID LINE_ITEM_ID
, CHARGE_ITEM_NUMBER CHARGE_ITEM_NUMBER
, ITEM_ID ITEM_ID
, PRICE PRICE
, QUANTITY QUANTITY
, PERIOD_NAME PERIOD_NAME
, CURRENT_EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE
, PREVIOUS_EFFECTIVE_DATE PREVIOUS_EFFECTIVE_DATE
, DESCRIPTION DESCRIPTION
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, START_DATE START_DATE
, DURATION DURATION
, REVISED_EFFECTIVE_DATE REVISED_EFFECTIVE_DATE
, REVISED_PRICE REVISED_PRICE
, PREVIOUS_PRICE PREVIOUS_PRICE
, VAT_TAX_ID VAT_TAX_ID
, REVENUE_CODE_COMBINATION_ID REVENUE_CODE_COMBINATION_ID
, RECEIVABLE_CODE_COMBINATION_ID RECEIVABLE_CODE_COMBINATION_ID
, ORG_ID ORG_ID
, RUN_ID RUN_ID
, ADDITIONAL_REFERENCE ADDITIONAL_REFERENCE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "IGI"."IGI_RPI_LINE_DETAILS_ALL"