eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_POLISH_PVT dependencies on FA_TRANSACTION_HEADERS

Line 571: -- adjustment in fa_transaction_headers or fa_adjustments.

567:
568: if (FA_POLISH_PVT.calling_mode = 'ADJUSTMENT') then
569: -- If we are currently doing an adjustment, no rows for the adjustment
570: -- will be been added yet, so there will not exist rows for the
571: -- adjustment in fa_transaction_headers or fa_adjustments.
572: l_transaction_type_code := 'ADJUSTMENT';
573:
574: else
575:

Line 588: from fa_transaction_headers

584: select transaction_type_code,
585: transaction_header_id
586: into l_transaction_type_code,
587: l_transaction_header_id
588: from fa_transaction_headers
589: where book_type_code = p_Book_Type_Code
590: and asset_id = p_Asset_ID
591: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
592: and transaction_header_id =

Line 595: from fa_transaction_headers

591: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
592: and transaction_header_id =
593: (
594: select max(transaction_header_id)
595: from fa_transaction_headers
596: where book_type_code = p_Book_Type_Code
597: and asset_id = p_Asset_ID
598: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
599: );

Line 1474: fa_transaction_headers th

1470:
1471: select dp.period_counter - 1
1472: into x_bef_trxn_period_counter
1473: from fa_mc_deprn_periods dp,
1474: fa_transaction_headers th
1475: where th.transaction_header_id = p_transaction_header_id
1476: and dp.book_type_code = p_Book_Type_Code
1477: and dp.set_of_books_id = p_set_of_books_id
1478: and th.date_effective between

Line 1486: fa_transaction_headers th

1482:
1483: select dp.period_counter - 1
1484: into x_bef_trxn_period_counter
1485: from fa_deprn_periods dp,
1486: fa_transaction_headers th
1487: where th.transaction_header_id = p_transaction_header_id
1488: and dp.book_type_code = p_Book_Type_Code
1489: and th.date_effective between
1490: dp.period_open_date and

Line 1506: fa_transaction_headers th

1502:
1503: select dp.period_counter - 1
1504: into x_bef_trxn_period_counter
1505: from fa_mc_deprn_periods dp,
1506: fa_transaction_headers th
1507: where th.transaction_header_id = p_transaction_header_id
1508: and dp.book_type_code = p_Book_Type_Code
1509: and dp.set_of_books_id = p_set_of_books_id
1510: and th.transaction_date_entered between

Line 1518: fa_transaction_headers th

1514:
1515: select dp.period_counter - 1
1516: into x_bef_trxn_period_counter
1517: from fa_deprn_periods dp,
1518: fa_transaction_headers th
1519: where th.transaction_header_id = p_transaction_header_id
1520: and dp.book_type_code = p_Book_Type_Code
1521: and th.transaction_date_entered between
1522: dp.calendar_period_open_date and

Line 1761: fa_transaction_headers th

1757:
1758: select dp.period_counter - 1
1759: into x_bef_trxn_period_counter
1760: from fa_mc_deprn_periods dp,
1761: fa_transaction_headers th
1762: where th.transaction_header_id = p_transaction_header_id
1763: and dp.book_type_code = p_Book_Type_Code
1764: and dp.set_of_books_id = p_set_of_books_id
1765: and th.transaction_date_entered between

Line 1785: fa_transaction_headers th

1781:
1782: select dp.period_counter - 1
1783: into x_bef_trxn_period_counter
1784: from fa_deprn_periods dp,
1785: fa_transaction_headers th
1786: where th.transaction_header_id = p_transaction_header_id
1787: and dp.book_type_code = p_Book_Type_Code
1788: and th.transaction_date_entered between
1789: dp.calendar_period_open_date and