APPS.OKL_QA_DATA_INTEGRITY dependencies on FA_ADDITIONS

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

Line 12111: fa_additions fa

12107: okl_txl_assets_b txl,
12108: okc_k_lines_b cleb,
12109: okc_statuses_b sts,
12110: fa_books fab,
12111: fa_additions fa
12112: where trx.id = txl.tas_id
12113: and trx.tsu_code = 'ENTERED'
12114: and trx.tas_type = 'CRB'
12115: and txl.kle_id = cleb.id

Line 12133: fa_additions fa

12129: txd.cost new_cost,
12130: fab.cost original_cost
12131: from okl_txd_assets_b txd,
12132: fa_books fab,
12133: fa_additions fa
12134: where txd.tal_id = p_tal_id
12135: and fab.book_type_code = txd.tax_book
12136: and fab.asset_id = fa.asset_id
12137: and fa.asset_number = txd.asset_number

Line 12422: FROM fa_additions

12418:
12419: CURSOR l_fa_csr(p_asset_id IN NUMBER) IS
12420: SELECT asset_category_id,
12421: asset_number
12422: FROM fa_additions
12423: WHERE asset_id = p_asset_id;
12424:
12425: l_fa_rec l_fa_csr%ROWTYPE;
12426: