DBA Data[Home] [Help]

APPS.OKL_VAR_INT_REAMORT_PVT dependencies on FA_BOOK_CONTROLS

Line 574: FA_BOOK_CONTROLS,

570: Select FA_BOOKS.ASSET_ID ASSET_ID,
571: FA_BOOKS.cost ASSET_COST,
572: FA_BOOKS.book_type_code BOOK_TYPE_CODE
573: from FA_BOOKS ,
574: FA_BOOK_CONTROLS,
575: OKC_K_LINES_B LINES,
576: OKC_LINE_STYLES_B STYLE,
577: OKC_K_ITEMS KITEM
578: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1

Line 584: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code

580: and LINES.cle_id = p_kle_id
581: and LINES.ID = KITEM.CLE_ID
582: and LINES.LSE_ID = STYLE.ID
583: and STYLE.LTY_CODE = 'FIXED_ASSET'
584: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code
585: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'
586: and FA_BOOKS.transaction_header_id_out is null;
587:
588: Cursor Deprn_csr (p_asset_id IN NUMBER,

Line 585: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'

581: and LINES.ID = KITEM.CLE_ID
582: and LINES.LSE_ID = STYLE.ID
583: and STYLE.LTY_CODE = 'FIXED_ASSET'
584: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code
585: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'
586: and FA_BOOKS.transaction_header_id_out is null;
587:
588: Cursor Deprn_csr (p_asset_id IN NUMBER,
589: p_book_type_code IN VARCHAR2) IS