APPS.FA_RETIREMENT_PUB dependencies on FA_ASSET_INVOICES

Line 3780: DELETE FROM FA_ASSET_INVOICES

3776: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;
3777:
3778: else
3779:
3780: DELETE FROM FA_ASSET_INVOICES
3781: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3782: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
3783:
3784: UPDATE FA_ASSET_INVOICES

Line 3784: UPDATE FA_ASSET_INVOICES

3780: DELETE FROM FA_ASSET_INVOICES
3781: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3782: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
3783:
3784: UPDATE FA_ASSET_INVOICES
3785: SET INVOICE_TRANSACTION_ID_OUT = '',
3786: DATE_INEFFECTIVE = ''
3787: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3788: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;

Line 6148: DELETE FROM FA_ASSET_INVOICES

6144: AND SET_OF_BOOKS_ID = l_asset_hdr_rec.set_of_books_id;
6145:
6146: else -- This is primary book
6147:
6148: DELETE FROM FA_ASSET_INVOICES
6149: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6150: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id
6151: AND INVOICE_TRANSACTION_ID_OUT is null;
6152:

Line 6157: UPDATE FA_ASSET_INVOICES

6153: /*
6154: * This reactivate record with FIXED_ASSETS_COST <> 0
6155: * since 0 cost row should not be appeared on source line window.
6156: */
6157: UPDATE FA_ASSET_INVOICES
6158: SET INVOICE_TRANSACTION_ID_OUT = '',
6159: DATE_INEFFECTIVE = ''
6160: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6161: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 6170: UPDATE FA_ASSET_INVOICES

6166: * After retirement, if cost is 0, INVOICE_TRANSACTION_ID_OUT
6167: * and DATE_INEFFECTIVE is populated with the same value as
6168: * INVOICE_TRANSACTION_ID_IN and DATE_EFFECTIVE.
6169: */
6170: UPDATE FA_ASSET_INVOICES
6171: SET INVOICE_TRANSACTION_ID_OUT = INVOICE_TRANSACTION_ID_IN,
6172: DATE_INEFFECTIVE = DATE_EFFECTIVE
6173: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6174: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 6957: FROM FA_ASSET_INVOICES

6953:
6954: CURSOR New_Asset_Invoices_C (c_asset_invoice_id NUMBER) is
6955: SELECT SOURCE_LINE_ID
6956: , FIXED_ASSETS_COST
6957: FROM FA_ASSET_INVOICES
6958: WHERE INVOICE_TRANSACTION_ID_IN = p_invoice_transaction_id
6959: AND ASSET_INVOICE_ID = c_asset_invoice_id;
6960:
6961: -- added a condition asset_id = c_asset_id for high-cost sql fix

Line 6966: FROM FA_ASSET_INVOICES

6962: CURSOR Old_Asset_Invoices_C (c_asset_id NUMBER) is
6963: SELECT ASSET_INVOICE_ID
6964: , FIXED_ASSETS_COST
6965: , SOURCE_LINE_ID
6966: FROM FA_ASSET_INVOICES
6967: WHERE INVOICE_TRANSACTION_ID_OUT = p_invoice_transaction_id
6968: AND ASSET_ID = c_asset_id;
6969:
6970: /*