SQL Depot

3 queries found for "Field Activity"

Get all from Field Activity

select * 
from CI_FA

uploaded by Nuno Rodrigues

Get specific Field Activity

select * 
from CI_FA
where 
FA_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Field Activities with Blank Dispatch Group

SELECT * FROM CI_FA fa, ci_sp sp, ci_sp_op_area op
where fa.sp_id=sp.sp_id
and  fa_type_cd='INSERT YOUR FA TYPE CD'
and sp.sp_id=op.sp_id
and sp.sp_type_cd='INSERT YOUR SP TYPE CD'
and fa.DISP_GRP_CD = ' '

uploaded by Muhammad Junaid

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