APPS.FA_RETIREMENT_PUB dependencies on FA_ASSET_INVOICES

Line 4059: DELETE FROM FA_ASSET_INVOICES

4055: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;
4056:
4057: else
4058:
4059: DELETE FROM FA_ASSET_INVOICES
4060: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4061: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
4062:
4063: UPDATE FA_ASSET_INVOICES

Line 4063: UPDATE FA_ASSET_INVOICES

4059: DELETE FROM FA_ASSET_INVOICES
4060: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4061: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
4062:
4063: UPDATE FA_ASSET_INVOICES
4064: SET INVOICE_TRANSACTION_ID_OUT = '',
4065: DATE_INEFFECTIVE = ''
4066: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4067: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;

Line 6496: DELETE FROM FA_ASSET_INVOICES

6492: AND SET_OF_BOOKS_ID = l_asset_hdr_rec.set_of_books_id;
6493:
6494: else -- This is primary book
6495:
6496: DELETE FROM FA_ASSET_INVOICES
6497: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6498: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id
6499: AND INVOICE_TRANSACTION_ID_OUT is null;
6500:

Line 6505: UPDATE FA_ASSET_INVOICES

6501: /*
6502: * This reactivate record with FIXED_ASSETS_COST <> 0
6503: * since 0 cost row should not be appeared on source line window.
6504: */
6505: UPDATE FA_ASSET_INVOICES
6506: SET INVOICE_TRANSACTION_ID_OUT = '',
6507: DATE_INEFFECTIVE = ''
6508: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6509: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 6518: UPDATE FA_ASSET_INVOICES

6514: * After retirement, if cost is 0, INVOICE_TRANSACTION_ID_OUT
6515: * and DATE_INEFFECTIVE is populated with the same value as
6516: * INVOICE_TRANSACTION_ID_IN and DATE_EFFECTIVE.
6517: */
6518: UPDATE FA_ASSET_INVOICES
6519: SET INVOICE_TRANSACTION_ID_OUT = INVOICE_TRANSACTION_ID_IN,
6520: DATE_INEFFECTIVE = DATE_EFFECTIVE
6521: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6522: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 7545: FROM FA_ASSET_INVOICES

7541:
7542: CURSOR New_Asset_Invoices_C (c_asset_invoice_id NUMBER) is
7543: SELECT SOURCE_LINE_ID
7544: , FIXED_ASSETS_COST
7545: FROM FA_ASSET_INVOICES
7546: WHERE INVOICE_TRANSACTION_ID_IN = p_invoice_transaction_id
7547: AND ASSET_INVOICE_ID = c_asset_invoice_id;
7548:
7549: -- added a condition asset_id = c_asset_id for high-cost sql fix

Line 7554: FROM FA_ASSET_INVOICES

7550: CURSOR Old_Asset_Invoices_C (c_asset_id NUMBER) is
7551: SELECT ASSET_INVOICE_ID
7552: , FIXED_ASSETS_COST
7553: , SOURCE_LINE_ID
7554: FROM FA_ASSET_INVOICES
7555: WHERE INVOICE_TRANSACTION_ID_OUT = p_invoice_transaction_id
7556: AND ASSET_ID = c_asset_id;
7557:
7558: /*