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_DEPRN_ROLLBACK_PVT dependencies on FA_ADJUSTMENTS

Line 831: INSERT INTO FA_ADJUSTMENTS(

827: and book_type_code = p_asset_hdr_rec.book_type_code
828: and transaction_header_id = l_thid
829: ;
830:
831: INSERT INTO FA_ADJUSTMENTS(
832: TRANSACTION_HEADER_ID
833: , SOURCE_TYPE_CODE
834: , ADJUSTMENT_TYPE
835: , DEBIT_CREDIT_FLAG

Line 914: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID

910: , GLOBAL_ATTRIBUTE20
911: , GLOBAL_ATTRIBUTE_CATEGORY
912: , DEPRN_OVERRIDE_FLAG
913: , TRACK_MEMBER_FLAG
914: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
915: , SOURCE_LINE_ID
916: , SOURCE_DEST_CODE
917: from fa_adjustments
918: where asset_id = p_asset_hdr_rec.asset_id

Line 917: from fa_adjustments

913: , TRACK_MEMBER_FLAG
914: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
915: , SOURCE_LINE_ID
916: , SOURCE_DEST_CODE
917: from fa_adjustments
918: where asset_id = p_asset_hdr_rec.asset_id
919: and book_type_code = p_asset_hdr_rec.book_type_code
920: and transaction_header_id = l_thid
921: ;

Line 929: INSERT INTO FA_ADJUSTMENTS_MRC_V(

925: fetch c_get_new_thid into l_trans_rec.transaction_header_id
926: , l_trans_rec.who_info.last_update_date;
927: close c_get_new_thid;
928:
929: INSERT INTO FA_ADJUSTMENTS_MRC_V(
930: TRANSACTION_HEADER_ID
931: , SOURCE_TYPE_CODE
932: , ADJUSTMENT_TYPE
933: , DEBIT_CREDIT_FLAG

Line 1012: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID

1008: , GLOBAL_ATTRIBUTE20
1009: , GLOBAL_ATTRIBUTE_CATEGORY
1010: , DEPRN_OVERRIDE_FLAG
1011: , TRACK_MEMBER_FLAG
1012: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1013: , SOURCE_LINE_ID
1014: , SOURCE_DEST_CODE
1015: from fa_adjustments_mrc_v
1016: where asset_id = p_asset_hdr_rec.asset_id

Line 1015: from fa_adjustments_mrc_v

1011: , TRACK_MEMBER_FLAG
1012: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1013: , SOURCE_LINE_ID
1014: , SOURCE_DEST_CODE
1015: from fa_adjustments_mrc_v
1016: where asset_id = p_asset_hdr_rec.asset_id
1017: and book_type_code = p_asset_hdr_rec.book_type_code
1018: and transaction_header_id = l_thid
1019: ;

Line 1173: delete from fa_adjustments

1169: if (p_mrc_sob_type_code <> 'R') then
1170: delete from fa_transaction_headers
1171: where transaction_header_id = l_thid;
1172:
1173: delete from fa_adjustments
1174: where asset_id = p_asset_hdr_rec.asset_id
1175: and book_type_code = p_asset_hdr_rec.book_type_code
1176: and transaction_header_id = l_thid;
1177:

Line 1192: delete from fa_adjustments_mrc_v

1188: and transaction_header_id_out = l_thid;
1189:
1190: else
1191:
1192: delete from fa_adjustments_mrc_v
1193: where asset_id = p_asset_hdr_rec.asset_id
1194: and book_type_code = p_asset_hdr_rec.book_type_code
1195: and transaction_header_id = l_thid;
1196: