SQL Depot

3 queries found for "Adjustment"

Get all from Adjustment

select * 
from CI_ADJ

uploaded by Nuno Rodrigues

Get specific Adjustment

select * 
from CI_ADJ
where 
ADJ_ID = 'XXXX'

uploaded by Nuno Rodrigues

Find out all the frozen adjustments along with account ID mentioned

SELECT AA.ADJ_ID, AA.SA_ID, AA.ADJ_TYPE_CD, AA.ADJ_STATUS_FLG, AA.CRE_DT, AA.ADJ_AMT, AA.COMMENTS, BB.ACCT_ID FROM CI_ADJ AA, CI_SA BB 
WHERE BB.SA_ID=AA.SA_ID and AA.ADJ_STATUS_FLG=50;

uploaded by Ankit Singhal

About & Contact

Why SQLDepot.com?
Because we've seen the same SQL code being written in different implementations - and that's a waste of time!

Who developed this?
Decrod Ltd - a consulting and application development company based in London, UK.

Is this an Oracle website?
This is not an Oracle website and we are not affiliated, associated, authorized, endorsed by, or in any way officially connected with Oracle Corporation.

Any questions?
Dont hesitate to get in touch. Our email is info@decrod.com