APPS.FA_INV_XFR_PUB dependencies on FA_MC_ADJUSTMENTS

Line 736: from fa_mc_adjustments

732: -adjustment_amount),
733: decode(debit_credit_flag,
734: 'CR', adjustment_amount,
735: -adjustment_amount)))
736: from fa_mc_adjustments
737: where asset_id = p_asset_id
738: and book_type_code = p_book_type_code
739: and period_counter_created = p_period_counter
740: and transaction_header_id = p_thid

Line 1121: delete from fa_mc_adjustments

1117: and period_counter_created = l_current_period_counter
1118: and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
1119: and adjustment_type = 'COST CLEARING';
1120:
1121: delete from fa_mc_adjustments
1122: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1123: and book_type_code = l_src_asset_hdr_rec.book_type_code
1124: and period_counter_created = l_current_period_counter
1125: and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)

Line 1162: delete from fa_mc_adjustments

1158: and period_counter_created = l_current_period_counter
1159: and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
1160: and adjustment_type = 'COST CLEARING';
1161:
1162: delete from fa_mc_adjustments
1163: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1164: and book_type_code = l_src_asset_hdr_rec.book_type_code
1165: and period_counter_created = l_current_period_counter
1166: and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)

Line 1204: UPDATE FA_MC_ADJUSTMENTS

1200: AND BOOK_TYPE_CODE = l_src_asset_hdr_rec.book_type_code
1201: AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
1202: AND ADJUSTMENT_TYPE = 'COST CLEARING';
1203:
1204: UPDATE FA_MC_ADJUSTMENTS
1205: SET CODE_COMBINATION_ID = l_clearing_ccid,
1206: DEBIT_CREDIT_FLAG = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
1207: ADJUSTMENT_AMOUNT = -1 * ADJUSTMENT_AMOUNT
1208: WHERE ASSET_ID = l_src_asset_hdr_rec.asset_id

Line 1222: UPDATE FA_MC_ADJUSTMENTS

1218: AND BOOK_TYPE_CODE = l_dest_asset_hdr_rec.book_type_code
1219: AND TRANSACTION_HEADER_ID = l_dest_trans_rec.transaction_header_id
1220: AND ADJUSTMENT_TYPE = 'COST CLEARING';
1221:
1222: UPDATE FA_MC_ADJUSTMENTS
1223: SET CODE_COMBINATION_ID = l_clearing_ccid,
1224: DEBIT_CREDIT_FLAG = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
1225: ADJUSTMENT_AMOUNT = -1 * ADJUSTMENT_AMOUNT
1226: WHERE ASSET_ID = l_dest_asset_hdr_rec.asset_id

Line 1240: update fa_mc_adjustments

1236: update fa_adjustments
1237: set source_dest_code = decode(transaction_header_Id,l_src_trans_rec.transaction_header_id, 'SOURCE','DEST')
1238: where transaction_header_id in (l_src_trans_rec.transaction_header_id,l_dest_trans_rec.transaction_header_id);
1239:
1240: update fa_mc_adjustments
1241: set source_dest_code =decode(transaction_header_Id,l_src_trans_rec.transaction_header_id, 'SOURCE','DEST')
1242: where transaction_header_id in (l_src_trans_rec.transaction_header_id,l_dest_trans_rec.transaction_header_id);
1243:
1244: -- Cannot Transfer Lines between expensed and Non Expensed Assets */