DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on FA_ADDITIONS_B

Line 368: FROM FA_ADDITIONS_B FAB

364: AND fa_cle.sts_code = fa_sts.code
365: AND fa_sts.ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED')
366: AND fa_cim.object1_id1 IS NOT NULL
367: AND NOT EXISTS(SELECT '1'
368: FROM FA_ADDITIONS_B FAB
369: WHERE FAB.Asset_id = TO_NUMBER(fa_cim.object1_id1)
370: )
371: AND EXISTS (SELECT '1'
372: FROM OKC_K_LINES_B fa_cle2,

Line 392: FA_ADDITIONS_B FAB

388: FROM OKC_K_LINES_B fa_cle,
389: OKC_LINE_STYLES_B fa_lse,
390: OKC_STATUSES_B fa_sts,
391: OKC_K_ITEMS fa_cim,
392: FA_ADDITIONS_B FAB
393: WHERE fa_cim.cle_id = fa_cle.id
394: AND fa_cim.dnz_chr_id = fa_cle.dnz_chr_id
395: AND fa_cle.dnz_chr_id = chrId
396: AND fa_cle.lse_id = fa_lse.id