AERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL"
WHERE TO_CHAR(GL_DATE,'RRRR') >=EXTRACT(YEAR FROM SYSDATE)-4 AND ORG_ID=85 and account_class='REV';
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";
//OR else you can use below script
tmpAERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";
AERO_BILLING_DATA:
LOAD *
Resident tmpAERO_BILLING_DATA
WHERE YEAR(GL_DATE) >= YEAR(TODAY()) - 4 AND ORG_ID=85 and account_class='REV';
DROP Table tmpAERO_BILLING_DATA;
Hope this will be helpful.
