APPS.EAM_ASSET_MOVE_PUB dependencies on WIP_EAM_PARAMETERS

Line 423: INTO l_intermediate_subinventory FROM WIP_EAM_PARAMETERS

419: FOR i IN p_asset_move_hierarchy_tbl.FIRST .. p_asset_move_hierarchy_tbl.LAST
420: LOOP
421: BEGIN
422: SELECT INTERMEDIATE_SUBINVENTORY
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

Line 668: from wip_eam_parameters

664: from MTL_PARAMETERS
665: where ORGANIZATION_ID = P_CURRENT_ORGANIZATION_ID;
666: --Added for the bug 7681240
667: select INTERMEDIATE_SUBINVENTORY into l_intermediate_subinventory
668: from wip_eam_parameters
669: where ORGANIZATION_ID = l_maint_organization_id;
670: EXCEPTION
671: WHEN No_Data_Found THEN
672: l_intermediate_subinventory := NULL;

Line 677: from wip_eam_parameters

673: END;
674:
675: BEGIN
676: select INTERMEDIATE_LOCATOR into l_intermediate_locator
677: from wip_eam_parameters
678: where ORGANIZATION_ID = l_maint_organization_id;
679: EXCEPTION
680: WHEN No_Data_Found THEN
681: l_intermediate_locator := NULL;

Line 748: --make nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,WIP_EAM_PARAMETERS.default_Subinventory) for the current SI

744: l_serial_number :=validAssets_rec.serial_number;
745: l_from_ser_number:=validAssets_rec.serial_number;
746: l_to_ser_number :=validAssets_rec.serial_number;
747: l_CURRENT_ORGANIZATION_ID:=validAssets_rec.CURRENT_ORG_ID;
748: --make nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,WIP_EAM_PARAMETERS.default_Subinventory) for the current SI
749:
750: l_current_subinventory_code :=nvl(validAssets_rec.CURRENT_SUBINVENTORY_CODE,l_intermediate_subinventory);
751: l_transaction_type_id:=p_transaction_type_id;
752: