APPS.FA_INV_XFR_PUB dependencies on FA_ADJUSTMENTS

Line 713: from fa_adjustments

709: -adjustment_amount),
710: decode(debit_credit_flag,
711: 'CR', adjustment_amount,
712: -adjustment_amount)))
713: from fa_adjustments
714: where asset_id = p_asset_id
715: and book_type_code = p_book_type_code
716: and period_counter_created = p_period_counter
717: and transaction_header_id = p_thid

Line 1114: delete from fa_adjustments

1110: end if;
1111:
1112: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1113:
1114: delete from fa_adjustments
1115: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1116: and book_type_code = l_src_asset_hdr_rec.book_type_code
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)

Line 1144: FROM FA_ADJUSTMENTS

1140: elsif (l_dest_asset_hdr_rec.period_of_addition = 'N' and l_src_asset_hdr_rec.period_of_addition = 'N') then
1141:
1142: SELECT CODE_COMBINATION_ID
1143: INTO l_clearing_ccid
1144: FROM FA_ADJUSTMENTS
1145: WHERE ASSET_ID = l_src_asset_hdr_rec.asset_id
1146: AND BOOK_TYPE_CODE = l_src_asset_hdr_rec.book_type_code
1147: AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
1148: AND ADJUSTMENT_TYPE = 'COST CLEARING'

Line 1155: delete from fa_adjustments

1151: if (l_interco_impact) then
1152:
1153: l_current_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
1154:
1155: delete from fa_adjustments
1156: where asset_id in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
1157: and book_type_code = l_src_asset_hdr_rec.book_type_code
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)

Line 1195: UPDATE FA_ADJUSTMENTS

1191: end if;
1192:
1193: else
1194:
1195: UPDATE FA_ADJUSTMENTS
1196: SET CODE_COMBINATION_ID = l_clearing_ccid,
1197: DEBIT_CREDIT_FLAG = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
1198: ADJUSTMENT_AMOUNT = -1 * ADJUSTMENT_AMOUNT
1199: WHERE ASSET_ID = l_src_asset_hdr_rec.asset_id

Line 1213: UPDATE FA_ADJUSTMENTS

1209: AND BOOK_TYPE_CODE = l_src_asset_hdr_rec.book_type_code
1210: AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
1211: AND ADJUSTMENT_TYPE = 'COST CLEARING';
1212:
1213: UPDATE FA_ADJUSTMENTS
1214: SET CODE_COMBINATION_ID = l_clearing_ccid,
1215: DEBIT_CREDIT_FLAG = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
1216: ADJUSTMENT_AMOUNT = -1 * ADJUSTMENT_AMOUNT
1217: WHERE ASSET_ID = l_dest_asset_hdr_rec.asset_id

Line 1236: update fa_adjustments

1232: end if; -- asset type and period of addition
1233:
1234: -- SLA: update the source_dest_code accordingly
1235: -- ideally would do this for cost in FAVIATB.pls but no good way to do so
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