VIEW: APPS.IGI_RPI_LINE_DETAILS_V

Source

View Text - Preformatted

SELECT jurld.charge_item_number, jurld.quantity, jurld.period_name, jurld.description, jurld.price, jurld.previous_effective_date, jurld.current_effective_date, jurld.revised_price, jurld.revised_effective_date, jurld.previous_price, jurld.additional_reference, jurld.item_id, jurld.vat_tax_id, jurld.line_item_id, jurld.standing_charge_id, jurld.accounting_rule_id, rr.name accounting_rule_name, jurld.start_date, jurld.duration, jurld.revenue_code_combination_id, jurld.receivable_code_combination_id, jurld.last_update_date, jurld.creation_date, jurld.last_updated_by, jurld.created_by, jurld.last_update_login, jurld.rowid row_id, jurld.org_id FROM igi_rpi_line_details jurld, ra_rules rr WHERE jurld.accounting_rule_id = rr.rule_id(+)

View Text - HTML Formatted

SELECT JURLD.CHARGE_ITEM_NUMBER
, JURLD.QUANTITY
, JURLD.PERIOD_NAME
, JURLD.DESCRIPTION
, JURLD.PRICE
, JURLD.PREVIOUS_EFFECTIVE_DATE
, JURLD.CURRENT_EFFECTIVE_DATE
, JURLD.REVISED_PRICE
, JURLD.REVISED_EFFECTIVE_DATE
, JURLD.PREVIOUS_PRICE
, JURLD.ADDITIONAL_REFERENCE
, JURLD.ITEM_ID
, JURLD.VAT_TAX_ID
, JURLD.LINE_ITEM_ID
, JURLD.STANDING_CHARGE_ID
, JURLD.ACCOUNTING_RULE_ID
, RR.NAME ACCOUNTING_RULE_NAME
, JURLD.START_DATE
, JURLD.DURATION
, JURLD.REVENUE_CODE_COMBINATION_ID
, JURLD.RECEIVABLE_CODE_COMBINATION_ID
, JURLD.LAST_UPDATE_DATE
, JURLD.CREATION_DATE
, JURLD.LAST_UPDATED_BY
, JURLD.CREATED_BY
, JURLD.LAST_UPDATE_LOGIN
, JURLD.ROWID ROW_ID
, JURLD.ORG_ID
FROM IGI_RPI_LINE_DETAILS JURLD
, RA_RULES RR
WHERE JURLD.ACCOUNTING_RULE_ID = RR.RULE_ID(+)