DBA Data[Home] [Help]

APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_TRANSACTION_HEADERS

Line 535: fa_transaction_headers b,

531: b.transaction_header_id transaction_header_id,
532: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
533: FROM fa_books d,
534: fa_additions c,
535: fa_transaction_headers b,
536: fa_retirements a
537: WHERE a.book_type_code = p_book_type_code
538: AND a.transaction_header_id_in = b.transaction_header_id
539: AND b.transaction_date_entered BETWEEN g_current_period_from_date1

Line 738: fa_transaction_headers b,

734: b.transaction_header_id transaction_header_id,
735: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
736: FROM fa_books d,
737: fa_additions c,
738: fa_transaction_headers b,
739: fa_retirements a
740: WHERE a.book_type_code = p_book_type_code
741: AND a.transaction_header_id_out = b.transaction_header_id
742: AND b.transaction_type_code = 'REINSTATEMENT'