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.EAM_ASSET_MOVE_PUB dependencies on EAM_ASSET_MOVE_TEMP

Line 74: DELETE FROM EAM_ASSET_MOVE_TEMP;

70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
71: END IF;
72:
73:
74: DELETE FROM EAM_ASSET_MOVE_TEMP;
75:
76: if (l_slog) then
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
78: 'Going to get the asset Hierarchy ');

Line 163: FROM EAM_ASSET_MOVE_TEMP;

159: ELSE l_move_txn_type_id := 21; -- In-Transit Inter Org Transfer
160: END IF;
161: END IF;
162: SELECT Count(*) INTO l_eam_asset_move_count
163: FROM EAM_ASSET_MOVE_TEMP;
164: if (l_slog) then
165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
166: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
167: end if;

Line 170: FROM EAM_ASSET_MOVE_TEMP

166: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
167: end if;
168:
169: SELECT Count(*) INTO l_prepare_count
170: FROM EAM_ASSET_MOVE_TEMP
171: WHERE PREPARE_STATUS = 'N';
172: if (l_slog) then
173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
174: 'The l_prepare_count is : '||l_prepare_count);

Line 402: FROM EAM_ASSET_MOVE_TEMP FOR UPDATE OF PREPARE_STATUS,

398:
399: CURSOR child_parent_cur
400: IS
401: SELECT *
402: FROM EAM_ASSET_MOVE_TEMP FOR UPDATE OF PREPARE_STATUS,
403: PREPARE_MSG;
404: BEGIN
405:
406: IF (l_ulog) THEN

Line 427: INTO EAM_ASSET_MOVE_TEMP

423: INTO l_intermediate_subinventory FROM WIP_EAM_PARAMETERS
424: WHERE ORGANIZATION_ID = p_asset_move_hierarchy_tbl(i).maint_org_id ;
425:
426: INSERT
427: INTO EAM_ASSET_MOVE_TEMP
428: (
429: INSTANCE_ID ,
430: SERIAL_NUMBER ,
431: GEN_OBJECT_ID ,

Line 492: FROM EAM_ASSET_MOVE_TEMP

488:
489: BEGIN
490: SELECT PREPARE_STATUS
491: INTO l_parent_status
492: FROM EAM_ASSET_MOVE_TEMP
493: WHERE gen_object_id=l_parent_object_id;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: SELECT 'U' INTO l_parent_status FROM dual;

Line 505: FROM EAM_ASSET_MOVE_TEMP

501:
502: BEGIN
503: SELECT PREPARE_MSG
504: INTO l_parent_msg
505: FROM EAM_ASSET_MOVE_TEMP
506: WHERE gen_object_id=l_parent_object_id;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: SELECT 'Unknown' INTO l_parent_msg FROM dual;

Line 516: UPDATE EAM_ASSET_MOVE_TEMP

512: END IF;
513: END;
514:
515: IF(l_parent_status ='N') THEN
516: UPDATE EAM_ASSET_MOVE_TEMP
517: SET PREPARE_STATUS = 'N',
518: PREPARE_MSG ='EAM_PAR_ASSET_FAIL'
519: WHERE CURRENT OF child_parent_cur;
520:

Line 549: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;

545: p_misc_rec_txn_type IN NUMBER :=NULL,
546: x_locator_error_flag OUT NOCOPY NUMBER,
547: x_locator_error_mssg OUT NOCOPY VARCHAR2)
548: IS
549: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
550: l_txn_if_id NUMBER;
551: l_SERIAL_NUMBER VARCHAR2(30);
552: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
553: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;

Line 602: FROM EAM_ASSET_MOVE_TEMP

598: -- Define a cursor with all the entries from Temp Table whose move status is 'Y' and 'MR'
599: CURSOR validAssets_cur
600: IS
601: SELECT *
602: FROM EAM_ASSET_MOVE_TEMP
603: WHERE prepare_status IN ('Y','MR')
604: AND TRANSACTION_HEADER_ID = p_header_id FOR UPDATE OF TRANSACTION_INTERFACE_ID;
605: BEGIN
606: --Dbms_Output.put_line('adding assets to interface tables');

Line 698: SELECT COUNT(*) into l_asset_count_for_MR FROM EAM_ASSET_MOVE_TEMP WHERE prepare_status LIKE 'MR';

694:
695:
696: --Locator control check up for intermediate subinventories and intermediate locators For Misc Rec for 7370638
697:
698: SELECT COUNT(*) into l_asset_count_for_MR FROM EAM_ASSET_MOVE_TEMP WHERE prepare_status LIKE 'MR';
699: --count required to verify whether any assets that are ready for Misc Receipt
700:
701: if(l_asset_count_for_MR > 0) THEN
702: if (l_intermediate_subinventory IS NULL) THEN

Line 818: UPDATE EAM_ASSET_MOVE_TEMP

814: end;
815:
816: INV_TRANSACTIONS.G_Header_ID := p_header_id;
817: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
818: UPDATE EAM_ASSET_MOVE_TEMP
819: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
820: WHERE CURRENT OF validAssets_cur;
821: IF(l_serial_number_control_code <> 1) THEN
822: SELECT mtl_material_transactions_s.nextval

Line 1050: -- dbms_output.put_line('updating EAM_ASSET_MOVE_TEMP after');

1046:
1047: -- Get the Transaction Status from the respective tables
1048: -- Update the Temporary Table with the transaction status
1049: --*******************important part**********************************
1050: -- dbms_output.put_line('updating EAM_ASSET_MOVE_TEMP after');
1051: FOR Txn_STAT_MTT_REC IN Txn_STAT_MMT_CUR(p_txn_header_id) LOOP
1052: EXIT WHEN Txn_STAT_MMT_CUR%NOTFOUND;
1053: UPDATE EAM_ASSET_MOVE_TEMP
1054: SET TRANSACTION_STATUS ='Failed',--NVL(Txn_STAT_MTT_REC.ERROR_CODE,'YES'),

Line 1053: UPDATE EAM_ASSET_MOVE_TEMP

1049: --*******************important part**********************************
1050: -- dbms_output.put_line('updating EAM_ASSET_MOVE_TEMP after');
1051: FOR Txn_STAT_MTT_REC IN Txn_STAT_MMT_CUR(p_txn_header_id) LOOP
1052: EXIT WHEN Txn_STAT_MMT_CUR%NOTFOUND;
1053: UPDATE EAM_ASSET_MOVE_TEMP
1054: SET TRANSACTION_STATUS ='Failed',--NVL(Txn_STAT_MTT_REC.ERROR_CODE,'YES'),
1055: TRANSACTION_MSG =Txn_STAT_MTT_REC.ERROR_EXPLANATION
1056: WHERE TRANSACTION_INTERFACE_ID = Txn_STAT_MTT_REC.TRANSACTION_INTERFACE_ID;
1057: -- AND instance_id = p_instance_id;