SQL Depot

1 query found for "Off Cycle Bill Generator Billable Charge"

Retrieve Off Cycle Bill Generator SAs

SELECT DISTINCT B.SA_ID
FROM C1_OFFCYC_BGEN_BCHG A, CI_BILL_CHG B
WHERE A.OFFCYC_BGEN_ID = 'INSERT_OFFCYC_GEN_ID'
And A.BILLABLE_CHG_ID = B.BILLABLE_CHG_ID
UNION
SELECT A.SA_ID from C1_OFFCYC_BGEN_SA A
WHERE A.OFFCYC_BGEN_ID =  'INSERT_OFFCYC_GEN_ID'

uploaded by Nuno Rodrigues

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