1. Tables and Views for Project Management
  2. PJB_VRM_AR_CLIN_AMT_V

PJB_VRM_AR_CLIN_AMT_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

CONTRACT_LINE_ID

INVOICE_LINE_ID

INVOICE_CURR_BILLED_AMT

LEDGER_CURR_BILLED_AMT

Query

SQL_Statement

SELECT

IDL.CONTRACT_LINE_ID CONTRACT_LINE_ID,

IDL.INVOICE_LINE_ID INVOICE_LINE_ID,

sum(IDL.INVOICE_CURR_BILLED_AMT) INVOICE_CURR_BILLED_AMT,

sum(IDL.LEDGER_CURR_BILLED_AMT) LEDGER_CURR_BILLED_AMT

FROM

PJB_INV_LINE_DISTS IDL,

PJB_INVOICE_HEADERS INH

WHERE IDL.BILLING_TYPE_CODE = 'EX'

AND IDL.INVOICE_ID = INH.INVOICE_ID

AND INH.INVOICE_STATUS_CODE ='ACCEPTED'

AND INH.EXCEPTION_FLAG = 'N'

AND IDL.LEDGER_CURR_BILLED_AMT IS NOT NULL

GROUP BY

IDL.CONTRACT_LINE_ID, IDL.INVOICE_LINE_ID