EBS Service Contracts Billing Analyzer Report issue
The signature for the "Receivables Interface Lines" section is:
SELECT RA.ORG_ID,
RA.INTERFACE_LINE_ID,
RA.INTERFACE_LINE_ATTRIBUTE1 CONTRACT_NUMBER,
RA.INTERFACE_LINE_ATTRIBUTE2 CONTRACT_NUMBER_MODIFIER,
RA.SALES_ORDER_LINE LINE,
RA.INTERFACE_LINE_ATTRIBUTE9 LINE_TYPE,
RA.INTERFACE_LINE_ATTRIBUTE4 BILL_FROM,
RA.INTERFACE_LINE_ATTRIBUTE5 BILL_TO,
RA.AMOUNT,
RA.TRX_DATE,
RA.GL_DATE,
RA.RULE_START_DATE
FROM RA_INTERFACE_LINES_ALL RA,
OKC_K_HEADERS_ALL_B OKHB
WHERE OKHB.ID = 0