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 68: DELETE FROM EAM_ASSET_MOVE_TEMP;

64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Entering ' || l_full_name);
65: END IF;
66:
67:
68: DELETE FROM EAM_ASSET_MOVE_TEMP;
69:
70: if (l_slog) then
71: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
72: 'Going to get the asset Hierarchy ');

Line 157: FROM EAM_ASSET_MOVE_TEMP;

153: ELSE l_move_txn_type_id := 21; -- In-Transit Inter Org Transfer
154: END IF;
155: END IF;
156: SELECT Count(*) INTO l_eam_asset_move_count
157: FROM EAM_ASSET_MOVE_TEMP;
158: if (l_slog) then
159: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
160: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
161: end if;

Line 164: FROM EAM_ASSET_MOVE_TEMP

160: 'The l_eam_asset_move_count is : '||l_eam_asset_move_count);
161: end if;
162:
163: SELECT Count(*) INTO l_prepare_count
164: FROM EAM_ASSET_MOVE_TEMP
165: WHERE PREPARE_STATUS = 'N';
166: if (l_slog) then
167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
168: 'The l_prepare_count is : '||l_prepare_count);

Line 389: FROM EAM_ASSET_MOVE_TEMP FOR UPDATE OF PREPARE_STATUS,

385:
386: CURSOR child_parent_cur
387: IS
388: SELECT *
389: FROM EAM_ASSET_MOVE_TEMP FOR UPDATE OF PREPARE_STATUS,
390: PREPARE_MSG;
391: BEGIN
392:
393: IF (l_ulog) THEN

Line 414: INTO EAM_ASSET_MOVE_TEMP

410: INTO l_intermediate_subinventory FROM WIP_EAM_PARAMETERS
411: WHERE ORGANIZATION_ID = p_asset_move_hierarchy_tbl(i).maint_org_id ;
412:
413: INSERT
414: INTO EAM_ASSET_MOVE_TEMP
415: (
416: INSTANCE_ID ,
417: SERIAL_NUMBER ,
418: GEN_OBJECT_ID ,

Line 479: FROM EAM_ASSET_MOVE_TEMP

475:
476: BEGIN
477: SELECT PREPARE_STATUS
478: INTO l_parent_status
479: FROM EAM_ASSET_MOVE_TEMP
480: WHERE gen_object_id=l_parent_object_id;
481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN
483: SELECT 'U' INTO l_parent_status FROM dual;

Line 492: FROM EAM_ASSET_MOVE_TEMP

488:
489: BEGIN
490: SELECT PREPARE_MSG
491: INTO l_parent_msg
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 'Unknown' INTO l_parent_msg FROM dual;

Line 503: UPDATE EAM_ASSET_MOVE_TEMP

499: END IF;
500: END;
501:
502: IF(l_parent_status ='N') THEN
503: UPDATE EAM_ASSET_MOVE_TEMP
504: SET PREPARE_STATUS = 'N',
505: PREPARE_MSG ='EAM_PAR_ASSET_FAIL'
506: WHERE CURRENT OF child_parent_cur;
507:

Line 535: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;

531: p_transfer_locator_id IN NUMBER :=NULL,
532: x_locator_error_flag OUT NOCOPY NUMBER,
533: x_locator_error_mssg OUT NOCOPY VARCHAR2)
534: IS
535: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
536: l_txn_if_id NUMBER;
537: l_SERIAL_NUMBER VARCHAR2(30);
538: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
539: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;

Line 588: FROM EAM_ASSET_MOVE_TEMP

584: -- Define a cursor with all the entries from Temp Table whose move status is 'Y' and 'MR'
585: CURSOR validAssets_cur
586: IS
587: SELECT *
588: FROM EAM_ASSET_MOVE_TEMP
589: WHERE prepare_status IN ('Y','MR')
590: AND TRANSACTION_HEADER_ID = p_header_id FOR UPDATE OF TRANSACTION_INTERFACE_ID;
591: BEGIN
592: --Dbms_Output.put_line('adding assets to interface tables');

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

680:
681:
682: --Locator control check up for intermediate subinventories and intermediate locators For Misc Rec for 7370638
683:
684: SELECT COUNT(*) into l_asset_count_for_MR FROM EAM_ASSET_MOVE_TEMP WHERE prepare_status LIKE 'MR';
685: --count required to verify whether any assets that are ready for Misc Receipt
686:
687: if(l_asset_count_for_MR > 0) THEN
688: if (l_intermediate_subinventory IS NULL) THEN

Line 800: UPDATE EAM_ASSET_MOVE_TEMP

796: end;
797:
798: INV_TRANSACTIONS.G_Header_ID := p_header_id;
799: INV_TRANSACTIONS.G_Interface_ID := l_temp_header_id;
800: UPDATE EAM_ASSET_MOVE_TEMP
801: SET TRANSACTION_INTERFACE_ID = l_temp_header_id
802: WHERE CURRENT OF validAssets_cur;
803: IF(l_serial_number_control_code <> 1) THEN
804: SELECT mtl_material_transactions_s.nextval

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

1000:
1001: -- Get the Transaction Status from the respective tables
1002: -- Update the Temporary Table with the transaction status
1003: --*******************important part**********************************
1004: -- dbms_output.put_line('updating EAM_ASSET_MOVE_TEMP after');
1005: FOR Txn_STAT_MTT_REC IN Txn_STAT_MMT_CUR(p_txn_header_id) LOOP
1006: EXIT WHEN Txn_STAT_MMT_CUR%NOTFOUND;
1007: UPDATE EAM_ASSET_MOVE_TEMP
1008: SET TRANSACTION_STATUS ='Failed',--NVL(Txn_STAT_MTT_REC.ERROR_CODE,'YES'),

Line 1007: UPDATE EAM_ASSET_MOVE_TEMP

1003: --*******************important part**********************************
1004: -- dbms_output.put_line('updating EAM_ASSET_MOVE_TEMP after');
1005: FOR Txn_STAT_MTT_REC IN Txn_STAT_MMT_CUR(p_txn_header_id) LOOP
1006: EXIT WHEN Txn_STAT_MMT_CUR%NOTFOUND;
1007: UPDATE EAM_ASSET_MOVE_TEMP
1008: SET TRANSACTION_STATUS ='Failed',--NVL(Txn_STAT_MTT_REC.ERROR_CODE,'YES'),
1009: TRANSACTION_MSG =Txn_STAT_MTT_REC.ERROR_EXPLANATION
1010: WHERE TRANSACTION_INTERFACE_ID = Txn_STAT_MTT_REC.TRANSACTION_INTERFACE_ID;
1011: -- AND instance_id = p_instance_id;