VRM_REVENUE_CONTRACTS_INF_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
REVENUE_CONTRACT_ID CUSTOMER_CONTRACT_DATE CUSTOMER_CONTRACT_NUMBER LEDGER_NAME CONTRACT_CLASSIFICATION_CODE

Query

SQL_Statement

SELECT vcch.CUSTOMER_CONTRACT_HEADER_ID REVENUE_CONTRACT_ID, vcch.CUSTOMER_CONTRACT_DATE, vcch.CUSTOMER_CONTRACT_NUMBER, ledger.NAME LEDGER_NAME, lkp.meaning CONTRACT_CLASSIFICATION_CODE FROM vrm_customer_contract_headers vcch, gl_ledgers ledger, VRM_LOOKUPS lkp WHERE vcch.ledger_id = ledger.ledger_id AND lkp.lookup_code (+) = vcch.CONTRACT_CLASSIFICATION_CODE AND lkp.lookup_type (+) = 'ORA_VRM_CONTRACT_CLASSIF_CODE'